Calculate Years, Months, Days elapsed

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 any date as an example

Enter 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

Related Articles to Read