don't calculate if no date is entered
From: Mike <Mike_at_discussions.microsoft.com>
Date: Sat, 1 Jul 2006 05:54:01 -0700 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 |
Thanks......... Received on Sat Jul 01 2006 - 05:54:01 PDT |
Click to report inappropriate content