don't calculate if no date is entered

From: Mike <Mike_at_discussions.microsoft.com>
Date: Sat, 1 Jul 2006 05:54:01 -0700


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......... Received on Sat Jul 01 2006 - 05:54:01 PDT

Click to report inappropriate content