Convert days to years and months

[h3lpme]

Hello

In column H5 I have a date of 25/03/2011 and in column I5 I have the formula =TODAY()-H5 so this shows the number of days as 2085. How can I change it so it shows the number in years and months or even just years? Its a spreadsheet that shows employees years of service.

Thanks for any help

 

[AlanY]

Hello

In column H5 I have a date of 25/03/2011 and in column I5 I have the formula =TODAY()-H5 so this shows the number of days as 2085. How can I change it so it shows the number in years and months or even just years? Its a spreadsheet that shows employees years of service.

Thanks for any help

divide that by 365.25 will give you the years, i.e 5.708 years

will that be enough?

 

[steve the fish]

This will give you years:

=DATEDIF(H5,TODAY(),"y")

or use "m" if you want months. Or "ym" if you want months ignoring years.

 

[Macropod]

Try:
=DATEDIF(H5,TODAY(),"y") &" years, "&DATEDIF(H5,TODAY(),"ym")&" months"

 

[h3lpme]

Thanks for everyones help. Didnt expect it so quick

Macropod your formula was perfect, thank you