Jul 01 2022 01:51 PM
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!!
Jul 01 2022 02:27 PM
=IF(FinishDate="", IF(CloseDate="", TODAY(), CloseDate), IF(CloseDate="", FinishDate, MIN(FinishDate, CloseDate)))-StartDate