Count Certain months between two dates

Hey guys!

I have found so much information on this site it's amazing! So first off thank you all!

I have a new question that I can't seem to get an answer for. May be far fetched.

I am trying to come up with a formula that will count CERTAIN months between two date ranges.

Example:

Cell A1 has 1/1/15
Cell A2 has 1/1/16

I need to count months June through November (6,7,8,9,10,11). The formula should return 6.


I know how to count all months between, but I can't think of how to get those 6 months counted. Thank you all for your help in advance!

Need more detailed information.

Will the date range ever span many years like 1/1/2013 to 5/27/2020 and should each month of each year be counted?

Should only full months that fall within the range get counted or should ANY month date that falls within the range get counted?

How about posting SEVERAL examples and show us what each result should be.

May be =(YEAR(A3)-YEAR(A2))*SUM(1*ISTEXT(OFFSET($D$1,MATCH(A5,D2:D13,0),0,MATCH(B5,D2:D13,0)-MATCH(A5,D2:D13,0)+1,))) formula would work

However please check the attached file. According your post #1

Hi All,

I try using DATEDIF .

In A1 start date, in B1 end date


=DATEDIF(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR(A2),MONTH(A2),DAY(EOMONTH(A2,0))),"M")+1

or more shortly:

=DATEDIF(EOMONTH(A1,-1),EOMONTH(A2,0),"M")

Hope that helps

Edit: formula counts all month, not only june-november.

l16=SUMPRODUCT((MOD(MONTH(C16)+ROW(INDIRECT("1:"&DATEDIF(C16,EOMONTH(F16,1),"m")))-2,12)+1>5)*(MOD(MONTH(C16)+ROW(INDIRECT("1:"&DATEDIF(C16,EOMONTH(F16,1),"m")))-2,12)+1<12))

Please Login or Register  to view this content.

Try this and copy towards down