DatedIf Not Working

%3CLINGO-SUB%20id%3D%22lingo-sub-2071903%22%20slang%3D%22en-US%22%3EDatedIf%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071903%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20calculate%20the%20shelf%20life%20remaining%20on%20an%20item%20using%20the%20manufactured%20date%20%26amp%3B%20the%20expiration%20date.%20Using%20the%20DatedIf%20function%20I%20am%20attempting%20to%20formulate%20the%20following%3A%20%3Ddatedif(mfg_date%2Cexpir_date%2C%22m%22)-%20this%20is%20per%20every%20forum%20I've%20found.%20Now%20when%20I%20start%20to%20enter%20the%20formula%2C%20I%20only%20get%20as%20far%20as%26nbsp%3B%3Ddatedif(mfg_date%2C%20before%20I%20get%20an%20error%20message.%20Once%20I%20put%20that%20comma%20%26amp%3B%20click%20the%20second%20cell%2C%20the%20error%20message%20occurs.%20The%20two%20date%20cells%20are%20utilizing%20short%20date%20formating%20so%20I%20know%20that's%20not%20the%20issue%20here.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated!%20Screenshots%20are%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2071903%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2071956%22%20slang%3D%22en-US%22%3ERe%3A%20DatedIf%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071956%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F933586%22%20target%3D%22_blank%22%3E%40cdersarkisian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20shall%20use%20semicolon%20instead%20of%20comma%20as%20delimiter%2C%20depends%20on%20your%20locale.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2071960%22%20slang%3D%22en-US%22%3ERe%3A%20DatedIf%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F933586%22%20target%3D%22_blank%22%3E%40cdersarkisian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20another%20screen%20shot%20that%20shows%20the%20formula%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I'm%20wondering%20if%20one%20or%20both%20of%20those%20dates%20just%20appear%20to%20dates%20properly%20formatted%2C%20but%20are%20actually%20text%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1610997512345.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247315i925D3C4FB8B33261%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mathetes_0-1610997512345.png%22%20alt%3D%22mathetes_0-1610997512345.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2071966%22%20slang%3D%22en-US%22%3ERe%3A%20DatedIf%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071966%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20in%20the%20U.S%20but%20I%20did%20try%20that-%20didn't%20work!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

9 Replies

@cdersarkisian 

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

@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

 

mathetes_0-1610997512345.png

 

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

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

@cdersarkisian 

 

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

@cdersarkisian 

On your file formula is without error

image.png

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

@cdersarkisian 

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