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...
Here's another screen shot that shows the formula works.
So I'm wondering if one or both of those dates just appear to dates properly formatted, but are actually text
- I formatted them as dates using the cell formatting function so they are definitely dates
Can you then, since none of our suggestions have helped yet, post a copy of the actual spreadsheet?
mathetes sure- i just added a copy
