Forum Discussion
DATE VALUE IS ZERO BASED ON NO DATA IN CELL
Not sure how to phrase this but …. I have a worksheet that I want to track due dates based on a the date we received document. I used a formula to automatically calculate that due date but the c...
Maybe try using a formula like this (See attached .xlsx file for additional reference):
If this doesn't help maybe you could provide further detail to your particular situation or a non-sensitive mock up file to help the community understand your inquiry better.
| =IF(D2="","",D2+30) |
or
| =IF(D2="",0,D2+30) |