Forum Discussion
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...
That's bizarre, it's still not working for me.
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
- 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 🙂
JHarFood , is it differ from =YEARFRAC(E2,TODAY(),1) ?
If you open the file attached to my post do you have any errors?
