DatedIf Not Working

[cdersarkisian]

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,expir_date,"m")- this is per every forum I've found. Now when I start to enter the formula, I only get as far as =datedif(mfg_date, before I get an error message. Once I put that comma & click the second cell, the error message occurs. The two date cells are utilizing short date formating so I know that's not the issue here. 

Any help would be appreciated! Screenshots are attached

[#2]

@cdersarkisian 

Perhaps you shall use semicolon instead of comma as delimiter, depends on your locale.

[#3]

@cdersarkisian 

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

[#4]

I'm in the U.S but I did try that- didn't work! @SergeiBaklan 

[#5]

I formatted them as dates using the cell formatting function so they are definitely dates

[#6]

@cdersarkisian 

Can you then, since none of our suggestions have helped yet, post a copy of the actual spreadsheet?

[#7]

@mathetes  sure- i just added a copy

[#8]

@cdersarkisian 

On your file formula is without error

[#9]

That's bizarre, it's still not working for me.

[#10]

@cdersarkisian 

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

[#11]

@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

[#12]

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 🙂

[#13]

@JHarFood , is it differ from =YEARFRAC(E2,TODAY(),1) ?

[#14]

@cdersarkisian 

=([end_date]-[start_date])/365.25   (or 30.4375, etc.) 

 works well enough for most purposes

[#15]

@cdersarkisian use ; instead of ,