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

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

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

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

--
Kind regards,

Niek Otten

"JulesM" wrote in message
...
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