excel count months in date range

Try this:

=DATEDIF(MIN(F:F),MAX(F:F),"m")+1

Thanks
Rob H

EDITED: added the +1

If you want just whole months, use the ROUNDDOWN function to round the result down to a whole number:

=ROUNDDOWN(AboveFormula,0)

Euro5,

You need to check before accepting solution, try below code:

=IF(MONTH(F2)&YEAR(F2)<>MONTH(LOOKUP(2,1/(F:F<>""),F:F))&YEAR(LOOKUP(2,1/(F:F<>""),F:F)),"1 Month",ROUND(YEARFRAC($F$2,MAX(F:F),1)*12,0)& " Months")

Select allOpen in new window

Please find attached comparing your accepted solution.
Month-Number.xlsx

Shums, maybe you need to read the question; the two ranges of dates were separate examples.

Example 1: Range of dates is 6 Nov to 22 Nov - result is 1 month
Example 2: Range of dates is 6 Nov and 28 Feb - result is 4 months

Your comparison assumes they are only one range.

With your sample, if you delete the 28 Feb from the list my solution shows only 1 month, as does yours.

Looks like Shum's suggestion is comparing each specific date within the range with the lowest date of the range.

I don't believe that is what was being asked. I believe the range is being looked at as a whole, requiring the number of months between earliest date in the range and the latest date in the range.