Computing.Net > Forums > Database > Help with calculating days between

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Help with calculating days between

Reply to Message Icon

Name: Hood
Date: January 22, 2009 at 12:33:46 Pacific
OS: Windows XP
CPU/Ram: centrino duo
Product: Lenovo / THINKPAD
Subcategory: General
Comment:

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.



Sponsored Link
Ads by Google

Response Number 1
Name: DARAFANN
Date: February 10, 2009 at 16:02:27 Pacific
Reply:

You could use and If...Then Statement is the originating cell is NULL


0

Response Number 2
Name: Mike (by mmcconaghy)
Date: February 13, 2009 at 14:57:28 Pacific
Reply:

Try

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

MIKE


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Help with calculating days between

Need help with Database in Access 2003 www.computing.net/answers/dbase/need-help-with-database-in-access-2003/669.html

Need help with SQL-query (access) www.computing.net/answers/dbase/need-help-with-sqlquery-access/209.html

help with ACT! 2006 www.computing.net/answers/dbase/help-with-act-2006/73.html