Having excel to calculate from start-date to end-date = number of months My formula do not work??

%3CLINGO-SUB%20id%3D%22lingo-sub-1586369%22%20slang%3D%22en-US%22%3EHaving%20excel%20to%20calculate%20from%20start-date%20to%20end-date%20%3D%20number%20of%20months%20My%20formula%20do%20not%20work%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1586369%22%20slang%3D%22en-US%22%3E%3CTABLE%20width%3D%22207px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22102px%22%3E1%2F2%2F2006%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3E1%2F03%2F2019%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20entering%20%3DDATEDIF(start%20cell%2C%20end-cell%2C%22Y%22)%26nbsp%3B%20but%20excel%20will%20not%20accept%20the%20formula%20%3F%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1586369%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1586429%22%20slang%3D%22de-DE%22%3ESubject%3A%20Having%20excel%20to%20calculate%20from%20start-date%20to%20end-date%20%3D%20number%20of%20months%20My%20formula%20do%20not%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1586429%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F758295%22%20target%3D%22_blank%22%3E%40Abildgaard2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20a%20small%20example%20with%20calculating%20the%20date%3C%2FSPAN%3E%3C%2FSPAN%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E*%20Beware%20of%20scammers%20posting%20fake%20support%20numbers%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1586442%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20excel%20to%20calculate%20from%20start-date%20to%20end-date%20%3D%20number%20of%20months%20My%20formula%20do%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1586442%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F758295%22%20target%3D%22_blank%22%3E%40Abildgaard2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20function%20works.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20387px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212197i9EC05A42AA6F576A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ebetter%20if%20you%20submit%20sample%20file%20to%20check%20what's%20wrong%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1586544%22%20slang%3D%22de-DE%22%3ESubject%3A%20Having%20excel%20to%20calculate%20from%20start-date%20to%20end-date%20%3D%20number%20of%20months%20My%20formula%20do%20not%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1586544%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F758295%22%20target%3D%22_blank%22%3E%40Abildgaard2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESometimes%20depending%20on%20the%20language%20selection%20it%20can%20happen%20that%20the%20quotes%20in%20the%20formula%20are%20not%20accepted%20and%20%23NAME%20or%20error%20appears.%20That%20happened%20to%20me%20once%20too.%20%3CBR%20%2F%3E%20Then%20you%20can%20quickly%20copy%20the%20formulas%20and%20off%20you%20go.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3DDATEDIF(F1%3B%20G1%3B%22%20Y%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EHere%20in%20a%20worksheet%20with%20the%20formula%20in%20action%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
1/2/20061/03/2019

 

I am entering =DATEDIF(start cell, end-cell,"Y")  but excel will not accept the formula ?? 

3 Replies
Highlighted

@Abildgaard2020 

 

Here is a small example with calculating the date.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

* Beware of scammers posting fake support numbers here.

Highlighted

@Abildgaard2020 

In general function works.

image.png

better if you submit sample file to check what's wrong

Highlighted

@Abildgaard2020 

 

Sometimes depending on the language selection it can happen that the quotes in the formula are not accepted and #NAME or error appears.That happened to me once too.
Then you can quickly copy the formulas and off you go.


=DATEDIF(F1;G1;"Y")

 

Here in a worksheet with the formula in action