Forum Discussion

cdersarkisian's avatar
cdersarkisian
Copper Contributor
Jan 18, 2021

DatedIf Not Working

I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. Using the DatedIf function I am attempting to formulate the following: =datedif(mfg_date...
Formulas and Functions
  • cdersarkisian's avatar
    cdersarkisian
    Copper Contributor
    Jan 18, 2021
    That's bizarre, it's still not working for me.
    • Tuvok's avatar
      Tuvok
      Copper Contributor
      Aug 04, 2023

      cdersarkisian use ; instead of ,

       

       

    • JHarFood's avatar
      JHarFood
      Copper Contributor
      Jul 02, 2021

      cdersarkisian I’m on my iPad and it reads the formula fine however I think it’s the “y” that is not working or any of its variants however I have no grounds backing that theory whatsoever so I really need someone’s help please, I really need this function to work for me lol

      • JHarFood's avatar
        JHarFood
        Copper Contributor
        Jul 02, 2021
        I found a solution 🙂 =((DAYS(TODAY(),E2))/365.25) and then reduced to 1 decimal which actually works great for me, maybe not for others though, hope this helps someone 🙂
    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Jan 18, 2021

      cdersarkisian 

      If you open the file attached to my post do you have any errors?

Resources