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!!
