converting days to months

J

Julie

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?
 
R

Rob van Gelder

Try:
=MONTH(A2) - MONTH(A1)

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

Harald Staff

Hi

Use Datedif to find number of months between two dates:
=DATEDIF(A1,B1,"m")
And you know of course that 28 days may or may not be a whole month, so this
is not a very precise way to measure time.

HTH. Best wishes Harald
 
Top