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.........