converting days to months

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

 

[Rob van Gelder]

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

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

 

[JE McGimpsey]

One way:

=DATEDIF(<start date>,<end date>,"m")

See

http://cpearson.com/excel/datedif.htm

 

[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