I'm trying to write an IF formula to calculate 4 types of data based on 2 dates.
Example:
Cell I4 (Install Start)
Data entered here, eg 20/10/2015
Cell J4 (Install End)
Date entered here, eg 25/10/2015
Cell K4 (Days to Install)
I have the following formula:
=IF(I4=0,"Enter Start Date",IF(I4=TODAY(),"In Progress",IF(I4>TODAY(),I4-TODAY(),IF(J4>TODAY(),"Completed"))))
Broken down:
Excel accepts the formula and doesn't show any errors, the first 3 requirements work but the part which I want to show "Completed" doesn't work regardless if the end date is greater than the start date: IF(J4>TODAY(),"Completed"))))
I may be approaching this all backwards, thank for your help!