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