Calculate months and weeks from two dates

[Raehan]

I am trying to add a formula to calculate duration between two dates in months and weeks. Not the total number of weeks between two dates but rather count the months first, and if less than month then count weeks.

For example:

Start date 2019-01-01
End date 2019-10-18

It should calculate 9 months 3 weeks.

Thanks a lot for your help.

Rae

[63falcondude]

Try this:

=DATEDIF(B1,B2,"m")&" months "&ROUNDUP((DAY(B2)-DAY(B1))/7,0)&" weeks"

[Raehan]

Thank you for providing such a speedy solution.

For the most part, it worked but if the dates are

Start date: 2019-02-25
End date: 2019-10-22

It shows 7 months -1 weeks

Is there a way to handle it?

[Roel Jongman]

Yes there is

I have made several solutions also with days because you last example is 7 months, 3 weeks and 6 days

Please see attachment because posing 4 options is a bit to much to explain in text.