If then ELSE

Occasional Visitor

Need help with a date calculation.


I Have 3 date columns: Start date, Finish date, Close date


Each row always has a start date and may or may not have the other column cells populated.

For each row I need to calculate (in days) the shortest interval from Start to either Finish, close, or if neither is populated, todays date.


Any help appreciated!!

1 Reply


=IF(FinishDate="", IF(CloseDate="", TODAY(), CloseDate), IF(CloseDate="", FinishDate, MIN(FinishDate, CloseDate)))-StartDate