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 posts:

1. Calculate number of Minutes between Dates
2. Calculate Revenue from Google Adsense for any Website
3. Combining Text and Values in one cell
4. Download Antivirus BitDefender Internet Security 2010 with Free License valid for 6 months
5. Useful Tips in Excel
6. Avira AntiVir Premium v9 with Free 90 Days License Key
7. Update Charts Automatically
8. Calculate CO2 emission from your Blog or Website.
9. Moving Between Precedent and Dependent Cells
10. Protecting cells, sheets, workbooks, and files