Forumla for length of time?

[AberdeenLass]

Hi there

I am trying to get a length of time in years and months between a specific date and today's date.

I have managed to get the years by using =YEAR(TODAY())-YEAR(D2), but i would like it to show the amount of years PLUS the amount of months.

Can anyone help?

Many thanks in advance!

[TMS]

Look at: http://www.cpearson.com/excel/datedif.aspx


Regards, TMS