Date difference

%3CLINGO-SUB%20id%3D%22lingo-sub-2152334%22%20slang%3D%22en-US%22%3EDate%20difference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152334%22%20slang%3D%22en-US%22%3EHi%20all%2C%20I%20have%20just%20learned%20excel%20and%20now%20I%20have%20to%20calculate%20the%20difference%20between%20two%20dates%3A%2025%2F11%2F19%20(G2)%20and%2015%2F10%2F15%20(C2).%20I%20need%20the%20number%20of%20months%20between%20those%20two%20dates.%20I%20tried%20this%20formula%3A%20%3DDATEDIF(G2%3BC2%3B%E2%80%9Dm%E2%80%9D)%3CBR%20%2F%3EBut%20this%20did%20not%20work.%20Who%20can%20help%3F%3CBR%20%2F%3E(I%20have%20Microsoft%20Office%20Professional%20Plus%202016)%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2152334%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2152339%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20difference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152339%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F973291%22%20target%3D%22_blank%22%3E%40Trudy123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20have%20to%20specify%20the%20earliest%20date%20first%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DDATEDIF(C2%3BG2%3B%22m%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi all, I have just learned excel and now I have to calculate the difference between two dates: 25/11/19 (G2) and 15/10/15 (C2). I need the number of months between those two dates. I tried this formula: =DATEDIF(G2;C2;”m”)
But this did not work. Who can help?
(I have Microsoft Office Professional Plus 2016)

Thanks in advance!
1 Reply

@Trudy123 

You have to specify the earliest date first:

 

=DATEDIF(C2;G2;"m")