Forum Discussion
Vogelfish
Jul 01, 2022Copper Contributor
If then ELSE
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 e...
HansVogelaar
Jul 01, 2022MVP
=IF(FinishDate="", IF(CloseDate="", TODAY(), CloseDate), IF(CloseDate="", FinishDate, MIN(FinishDate, CloseDate)))-StartDate