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

MindreVetande

Iron Contributor

Nov 19, 2020

Tolormo

ROUNDUP?

=ROUNDUP(DATEDIF(A1,B1,""m""),0)

=DATEDIF(A1,B1,""m"")+1

depending on how you want to handle "exactly 24 months"

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