Forum Discussion

lkm0707's avatar
lkm0707
Copper Contributor
May 22, 2018

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...
Formulas & Functions
Need Help
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 31, 2018

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.

Tanya525's avatar
Tanya525
Copper Contributor
Mar 12, 2024

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

DESCRIPTIONVin NumberID #PlatePlateRegistration ExpDays
 Jeep Wrangler UL1C4BJWD47 CIB-41912/8/2024271
Cargo Van1FTNE2EW42 CGE-7552/13/2024-28
 Ford F550  1FDUF5G10 CHM-913 -45363
  • SnowMan55's avatar
    SnowMan55
    Bronze Contributor
    Mar 14, 2024

    Tanya525 

    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.

Resources