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...
Forum Discussion
Hey lkm0707-
Just wanted to follow up with you and see if you were able to resolve your issue or if you still needed more assistance? Please feel free to post back to the community! Always happy to help.
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.
