Forum Discussion

Copper Contributor

Nov 19, 2020

Solved

Datedifference

Hello Excel Community, I am having trouble with this Datedif-formula. I want Excel to count the difference in months between two dates. This does work, but not in every case like I want it to. ...

excel

SergeiBaklan
Nov 19, 2020
MindreVetande

Perhaps

=DATEDIF(A1,B1,"M")+1*(DAY(B1)<>DAY(A1))

SergeiBaklan

Diamond Contributor

Nov 19, 2020

MindreVetande

Perhaps

=DATEDIF(A1,B1,"M")+1*(DAY(B1)<>DAY(A1))

MindreVetande

Iron Contributor

Nov 19, 2020

SergeiBaklan

Much better. I honestly don't know what i meant with the ROUNDUP thing.

This should also work (except for day Zero)

=DATEDIF(A1,B1-1,"M")+1