Datedif function

Question

Hi, I would like to calculate the months between 2 dates, but the datedif function does not seem to work in my version Excel (version 16;68). I'm a Mac user.

Can someone plse help me? What should I do?

hansvogelaar · Answer

Sofie_Hermans&nbsp;
Here is Microsoft's documentation: DATEDIF Function&nbsp;

doug_robbins_word_mvp · Answer

I am not sure what you mean by Datedif function.  However there is a VBA command DateDiff.  I am not sure however, if it is supported on a Mac.

See:
https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/datediff-function?f1url=%3FappId%3DDev11IDEF1%26l%3Den-US%26k%3Dk(vblr6.chm1012950);k(TargetFrameworkMoniker-Office.Version%3Dv16)%26rd%3Dtrue

riny_van_eekelen · Answer

Sofie_Hermans&nbsp;Doesn't work or you cant find it in the list of available functions? Probably the latter, since DATEDIF is not an official Excel function. It merely exists to be compatible with old Lotus-1-2-3 files.&nbsp;The link below says all about it.https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c&nbsp;

harshulz · Answer

Sofie_Hermans&nbsp;hi sofie,i also tried this function, actually function is not recognized but it works as shown below&nbsp;

Forum Discussion

Datedif function

4 Replies

Resources