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

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?