Hi Fiona,
The correct answer is going to depend on how well you want to define
what constitutes a months worth of days. Not all months have the same
number of days. If you start on the the 31st and end on the last day
of the next month with 30 days was that a month, if you go to the
1st day of the next month do you then have one month. Likewise
if you start at the end of a 30 day month and end at the 30th of a 31 day
month do you have a month or are you a day short of month.

Take a look at DATEDIF it will probably do what most people
would expect as an answer. If you have Excel 2000 (and I think Excel 2003) you
will find it in HELP otherwise you won't (don't know about MACs). In any case
it has always been in Excel and was once documented in the MS KB as the
"Undocumented Function" then they removed the article..

Anyway whether or not it is in your Excel HELP, you should look at
Chip Pearson's page, which has some additional explanations, and examples:
http://www.cpearson.com/excel/datedif.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fiona" wrote in message ...
if I have a date in column A and a date in column B, what would the formula be
to find out how many months inbetween the two dates?

--
fiona05