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

J

JulesM

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
 
N

Niek Otten

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