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...
Matt Mickle Good Morning, I am having a similar problem. And hope that you can assist. It is a file on expiration dates of registrations and insurance. My calculations work fine. Except if I leave either the expiration date or insurance exp date out it provides -45363 in the cell when I would like it to show no data in the cell if the expiration date is not entered. see below the first two are correct the third is showing the -45363
| DESCRIPTION | Vin Number | ID # | Plate | Plate | Registration Exp | Days |
| Jeep Wrangler UL | 1C4BJWD | 47 | CIB-419 | 12/8/2024 | 271 | |
| Cargo Van | 1FTNE2EW | 42 | CGE-755 | 2/13/2024 | -28 | |
| Ford F550 | 1FDUF5G | 10 | CHM-913 | -45363 |
If those Registration Exp[iration] values are in column F, then any of these formulas should work for row 4 of column G:
=IF( ISBLANK(F4), "", F4 - TODAY() )
=IF( F4 = "", "", F4 - TODAY() )
=IF( F4 = 0, "", F4 - TODAY() )Other techniques are possible, but a formula such as above is the simplest.