Hi,

I'd suggest that you convert all figures to months and then divide by 12.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sandeep Nair" <Sandeep wrote in message
...
How can i add months or years and get the answer in the same format. For
example, adding 2 years 10 months and 1 year 3 months. The answer should
be 4
years 1 month. If we do this calculation in excel, as usual it will give
the
answer as 3.13 (2.10+1.3).

Regards
Sandeep Nair