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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Space at end of multi page list to accommodate new entries 1
Use TODAY() function as the criteria in a SUMIF formula 1
Computing Elapsed Time 4
Publisher is filling blank lines with data 2
How can I copy data produced by a formula, not the formula? 2
Conditional formatting with dates 7
number of months and days between two dates without approximation 3

Top