Counting days formula

  • Thread starter Thread starter cardingtr
  • Start date Start date
C

cardingtr

Here is the formula I use:

=DATEDIF(B6,TODAY(),"D")

to calculate # of days from date I entered.
However when I left the cell blank, it gives it a value of 38607.
How can I get it blank if I don't enter a date? It affect the whole
spreadsheet.

Thanks.
 

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

Expanding Date formula 1
Subtracting Dates 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formula Error 4
Formula Error 6
Summary of Difference between dates in years, months, days 3
changed DOB to age, but if no DOB need cell to be empty. 4
date of birth age formula 8

Back
Top