Tip Printed from ExcelTip.com
Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel


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