don't calculate if no date is entered
 

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

don't calculate if no date is entered
 

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


--
darkxer0x
------------------------------------------------------------------------
darkxer0x's Profile: http://www.excelforum.com/member.php...o&userid=35967
View this thread: http://www.excelforum.com/showthread...hreadid=557567

don't calculate if no date is entered
 

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" wrote in message
...
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.........

don't calculate if no date is entered
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557567