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

@Vogelfish 

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