Forum Discussion
cdersarkisian
Jan 18, 2021Copper Contributor
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...
cdersarkisian
Jan 18, 2021Copper Contributor
I formatted them as dates using the cell formatting function so they are definitely dates
mathetes
Jan 18, 2021Gold Contributor
Can you then, since none of our suggestions have helped yet, post a copy of the actual spreadsheet?
- cdersarkisianJan 18, 2021Copper Contributor
mathetes sure- i just added a copy
- SergeiBaklanJan 18, 2021Diamond Contributor
- cdersarkisianJan 18, 2021Copper ContributorThat's bizarre, it's still not working for me.