calculating years and months between 2 dates

[rajgopal]

How can I calculate years and months between 2 dates

 

[Frank Kabel]

Hi
have a look at the following site (using DATEDIF)
http://www.cpearson.com/excel/datedif.htm

 

[Guest]

Assuming the 2 dates are incolumns A and B, enter =B1-A1 into C1 and then format, cells, number, custom and type yy:mm