that was really cool! thank you so much!

"Rob van Gelder" wrote:

I got that wrong - really wrong. Sorry about that.

Take a look at Chip Pearson's page on DATEDIF instead:
http://www.cpearson.com/excel/datedif.htm

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Rob van Gelder" wrote in message
news:...
Try:
=MONTH(A2) - MONTH(A1)

Or:
=MONTH(A2) - MONTH(A1) + IF(DAY(A2)DAY(A1), 1, 0)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Julie" wrote in message
...
I was able to convert start date and and end date to the number of days
inbetween the two dates. Does anyone know how to then convert the number
of
days into months?