View Single Post
  #6   Report Post  
Rob van Gelder
 
Posts: n/a
Default

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?