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
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)
--
Kind regards,
Niek Otten
"JulesM" <[email protected]> wrote in message
news:[email protected]...
>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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks