Count Months Between Two Dates in Excel - Two Formula Examples

In this video, we will count the months in a range of dates. We will demonstrate two Excel formula examples to achieve this. Pick your favourite.

Let me know what formula you prefer in the comments.

Or do you have a different formula that you would use?

This video uses just Excel formulas. No Power Query! No PivotTables! No Macros!

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[robertlohman]

I prefer the Sum product example here. Great tutorial. Thank you.

[wkbfergie]

I have been looking for this formula for the past 3 hours! The second formula worked for me. Thank you so much!

[alexanderkamilov]

Thank you for this video!! Straight to the point!! 😀💪💪👍👍

[joseenciso]

Awesome.... All night trying to find the solution and and explanation to the --

[anneliesehanson]

This is so amazingly helpful and well explained! I love the more conversational tone you use.

[stenionet]

I could not find the solution in my language(portuguese), so I searched in English and find two solutions for my problem.
Thank you.

[wayneedmondson]

Hi Alan.. great challenge. Here's another solution using IF (I used cardinal numbers in D2:D13 and my date data went from A2:A50). In cell E2: ={SUM(IF(MONTH($A$2:$A$50)=D2, 1, 0))} - and copy down to E13. Of course it requires CSE because of IF.. but another way to get the job done. If I have to choose one, I would use SUMPRODUCT with the double unary (--), as you demonstrated. Thanks for the inspiration to create. Thumbs up!

[sparshgarg]

Thank you so much man
It was a great help!

[colinhuntley]

hi alan, i watch with awe, how you make things so easy! as i am really not doing any projects which would need these formulas, i am not really familiar with either of the formulas, although i have at least heard about them... i would be really pleased with myself if i knew how to use them both with any confidence (practice makes perfect, i suppose). after having the watched the video for a second time, the sumproduct example would be my choice. as always, alan, a very big thanks for another great video. regards colin

[Akshaykumar-kkvh]

Always great Mr .Alan I like sumproduct

[EricaDyson]

Great. Thanks SUMPRODUCT and !* for me. Very useful.

[adamkidwell]

Hi there. Does it work if I'm trying to sort by month but also take into account the year? as in I want a total from January 2018 and January 2019 separately?

[birebhushan]

hiii..i m bhushan
great count calculation sir
but my problem is if some data in front of another cell january, February, march...etc...in pluse and minus value how to count in positive and negative value by month vise ...???
please help sir

[Manhe]

Just saw this video because I need to extract the months of dates from 2002 to 2020, any pointers to do it? I am not an Excel expert by any means and barely could follow your instructions because my native language is Spanish, thank you

[dheerajgond]

How to add one more criteria I want count that number which more than 100.
Please 🙏 suggest me

[md.saifulislamtuku]

Sir,
Place make video missing serial number highlight this cell. Not another sheet, row&columns .
thanks

[DIGITAL_COOKING]

countifs is better because it's faster than array formula which is slow in this case where it should do the calculation row by row

[funny_bunny]

Following first formula, dated on 1st Jan data is not counting. Pls help!

[Sandeepkumar-wouy]

if ITS FEB data not getting correctly for 2022 "=COUNTIFS('Sheet 1'!$B:$B, ">="&'Sheet 2'!D4, 'Sheet 1'!$B:$B, "<="&EOMONTH(D4, 0))could you please help me on this why am not getting correct number

[convivialist]

too many ads mate. understand why. but too many. 1 ad ok