Help with calculating days between

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 •

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

Report •

February 13, 2009 at 14:57:28



Report •

Related Solutions

Ask Question