don't calculate if no date is entered

G

Guest

I need to calculate days passed up to today, using the formula
DAYS360(D2,TODAY()) which works great. However, in a row where a date has
not been entered yet the formula returns 38314, which I assume is calculating
from Jan 1900. What can I do to get Excel to just display 0 if no date is
enetered yet?

ex. of worksheet


| A | B | C |
D |
________________________________________________________________
1 |DAYS OUT | NAME | DVD TITLE | DATE CHECKED OUT |
________________________________________________________________
2 |20 | John Doe | Chicken Little | Wed, Apr 20,
2006 |
________________________________________________________________
3 |38314 | | |
|
_________________________________________________________________

Thanks.........
 
F

Fred Smith

While we're at it, DAYS360 will not calculate "days passed up to today" in all
cases. You most likely want a simple subtraction, as in:

=today()-d2
 

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

No date entered still pulls a reult '1' through?? 1
If cell is blank automatically enter today's date in the same cell 21
date of birth age formula 8
Calculate eligibility/enrollment date 8
formula to calculate total rent charges 4
Calculate the number of days from a specific date 5
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculate Payment Days and Date 3

Top