Thread: Adding Year,month and days

Hi

In Microsoft excel formula, how to write this formula

Y = 12m, 12m = 365 days, 30 or 31 days per month

Ex: 2 yrs, 10m, 20 days. If i add the same i.e. 2 yrs, 10m, 20 days,

It should show the result.

How may years, months and days?

Please advice.

All the help will be greatly appreciated.

Regards
Sridhar Reddy