Help with calculating days between

Lenovo / THINKPAD
January 22, 2009 at 12:33:46
Specs: Windows XP, centrino duo
I'm capturing number of days between two dates with the formula =Now()-N9 in cell O9(for this particular cell, the formula repeats from O9 to O58. The question is how do I avoid the "39835" number from poping up when the date in N is not available yet.


See More: Help with calculating days between

Report •


#1
February 10, 2009 at 16:02:27
You could use and If...Then Statement is the originating cell is NULL

Report •

#2
February 13, 2009 at 14:57:28
Try

=IF(ISBLANK(N9),"",Now()-N9)

MIKE


Report •

Related Solutions


Ask Question