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