Finding Months Between Two Dates

[jemmers]

Hello All,

I need help finding a formula to calculate the number of months between two dates. I've attached an Excel spreadsheet with sample data. Some are in the future, and some are in the past.

Excel Help.xlsx

I appreciate everyone's help.

Jen

[Jonmo1]

We need a definition of what qualifies a month to be counted.
If the End date is the first of the month, should that month be counted?
Or if the Begin date is the last day of the month, should that month be counted?
Or should a month only be counted if it passes in it's entirety?

Can you manually enter your expected results into column C and repost the book?

[AlKey]

See if this will work for you

=DATEDIF(A2,B2,"m")

	A	B	C
1	Date One	Date Two	Months Between
2	7/15/2010	9/13/2012	25
3	6/13/2011	10/1/2013	27
4	5/11/2012	10/19/2014	29
5	4/9/2013	11/6/2015	30
6	3/8/2014	11/23/2016	32
7	2/4/2015	12/11/2017	34
8	1/3/2016	12/29/2018	35
9	12/1/2016	1/16/2020	37
10	10/30/2017	2/2/2021	39
11	9/28/2018	2/20/2022	40
12	8/27/2019	3/10/2023	42
13	7/25/2020	3/27/2024	44
14	6/23/2021	4/14/2025	45
15	5/22/2022	5/2/2026	47

[jemmers]

Can you manually enter your expected results into column C and repost the book?

Okay, I've attached a book with the first 3 calculated as to what I'm hoping to find.

We need a definition of what qualifies a month to be counted.

Literally just moving from one month to the next, I'm not looking for exact 30/31 days. Just from November to December, etc.

If the End date is the first of the month, should that month be counted?

No, I only need the next month to count.

Or if the Begin date is the last day of the month, should that month be counted?

Yes, I still need to account for that month.

Or should a month only be counted if it passes in it's entirety?

No. I'm just looking for how many calendar months are between the two.

Excel Help.xlsx

I hope this helps.

[jemmers]

See if this will work for you

=DATEDIF(A2,B2,"m")

It worked like a dream, thank you very much!

Reputation added

[BNull@Tenneco]

Is this what you're looking for? Excel Help.xlsx This is based on the average number of days in a month (accounting for leap years). It's simply column B minus column A all divided by said average. Hope this helps!!

[AlKey]

Thank you for feedback!

[jemmers]

BNUll, that works even better, thank you!

[Jonmo1]

Nevermind, appears you already have solution.

[Tony Valko]

If these were the dates:

A2 = 11/30/2012

B2 = 12/1/2013

What result would you expect? If you expect the result to be 2, then try this formula:

=DATEDIF(A2-DAY(A2)+1,B2,"m")+1