Date difference

Copper 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")