Count # of months in date range

Hi,

I have a list of hundreds of dates in a single column. I'm trying to figure out how many months are spanned by the list. The earliest and latest dates are not explicitly singled out or located anywhere specific - they may be placed anywhere in the list.

Until now, I've been using this:

=MONTH(MAX(DateRange))-MONTH(MIN(DateRange))+1

...where "DateRange" is the column of data containing the hundreds of dates. This worked well until recently where there are now dates across multiple years. So, for example, if the earliest date is 12/27/07 and the latest date is 3/31/08, that should be 4 months (Dec, Jan, Feb, Mar), instead of 10 as the formula would churn out (12-3+1).

How can I manipulate the formula to get 4? Thanks in advance-

JChandler

Please Login or Register  to view this content.

Thank you very much, that worked well.

I've since encountered another problem.

If the span of months was from Nov '07 to Jun '08, but there are no Feb dates included anywhere in the long list of dates, what function would count 7 instead of 8?

Thanks again in advance.