Excel 97 - finding No. of Months between 2 date ranges

Hi

I need to find how to work out the total number of months
where I have a list of fixed start and end dates, always
beging on the first day and end on the last day of a
calendar month;

Start - 01/02/03
End - 30/09/09

The number needs to be returned as an integer ranging
between 1 and 12, though I'll be working on quarters, so
the number will be between 0 and 3 maximum...any ideas?

Thanks

Roy

One way is to use the YEARFRAC function. This can then be
multiplied by 12 to get the number of months. You can put
in different options to work out the number of days in the
month, days in year (30/360 etc).

Alternatively you can do the same sort of thing by
subtracting the 2 dates, divide by 365 and then mulitply
by 12. Again it will provide the number of months which
can be rounded to suit (there can be 7 or 8 months between
February and September depending on whether you count the
first month or not).


Tony
-----Original Message-----
Hi

I need to find how to work out the total number of months
where I have a list of fixed start and end dates, always
beging on the first day and end on the last day of a
calendar month;

Start - 01/02/03
End - 30/09/09

The number needs to be returned as an integer ranging
between 1 and 12, though I'll be working on quarters, so
the number will be between 0 and 3 maximum...any ideas?

Thanks
.