In order to calculate the time elapsed from a certain date, we will use a birthdate as an example

**Enter birthday date in cell A1:** 01/01/1980

**To calculate the number of years from the date, enter the following formula in cell B1**: =YEAR(TODAY())-YEAR(A1)

**The result (rounded):** 23 Years

**For a decimal solution, use the following formula:** =DATEDIF(A1,TODAY(),”m”)/12

The result: 23.25 Years

**To calculate the number of months from the date, enter the following formula in cell D1: **=DATEDIF(A1,TODAY(),”m”)

**The result:** 279 Months

**To calculate the number of days from the date, enter the following formula in cell E1:** =DATEDIF(A1,TODAY(),”d”)

**The result:** 8499 Days

PS: A lot of site, avoid to calculate date in Excel using DATEDIF function, due to some of bugs, as DATEDIF function dont have any documentation in Excel Help file,

But, Microsoft continuously giving this feature / formula in all new version.

In case if you also want to avoid DATEDIF function, you can use manual calculation.. like below…

**=INT((TODAY()-A1)/365.25) & ” years , ” & INT(MOD((TODAY()-A1)/365.25,1)*12) & ” months and ” & INT(MOD((TODAY()-A1)/30.4375,1)*30.4375) & ” days”**

it will give day difference in Year Month and in days. You can use A2 in case of today, where A2 is the greater day that A1 and gives you Elapsed time between these 2 dates..

How can calculate year &month in continus next row. ie.

dec.13 =30 years

jan.14 =30 years 1 Month

feb.14 =30 years 2 month

asnd so on upto the age of 65 years.

pls. reply on my mail.

i will be very thankfull to you.