don't calculate if no date is entered

[Mike]

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

[darkxer0x]

If(d2 = 0; 0; Days360(d2,today()))

[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

--
Regards,
Fred


"Mike" <[email protected]> wrote in message
news:[email protected]...
>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.........
>
>

[daddylonglegs]

=if(d2,today()-d2,0)