Number of days between 2 dates, if end date is blank assume todays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need an excel formula to calculated the number of days between 'Start Date'
and 'End Date'. IF the 'End Date' is null I want to use todays date.

Please Help
 
=IF(B1="",TODAY(),B1)-A1
Format as number, not as date (which Excel will do automatically)
 
Back
Top