How to Calculate Years from Today in Excel (4 Easy Ways)

There is no built-in function to calculate the years between a past or future date and today’s date in Excel. However, you can do it by applying a combination of some simple functions. As an illustration, we have the starting date of current and upcoming projects of a company. We will calculate the time that has passed and how much time is left on specific projects.

Dataset to Calculate Years in Excel from Today


Method 1 – Combining DAYS & NOW Functions to Find Years from Today

  • Type the following formula in an empty cell.
=DAYS(NOW(),C6)/365

Here, the NOW function provides the current time, and then the DAYS function calculates the difference between today and the provided day in cell C6.

Combine NOW & DAYS Function to Calculate Years in Excel from Today

  • After pressing ENTER, you will get the amount of years that have passed between the starting date and today’s date.

Using NOW & DAYS Function to Calculate Years in Excel from Today

  • For all other current projects, you can calculate the years in a similar manner. You can also use the Fill Handle icon to copy the formula.

Use Fill Handle Icon to Copy Formula

Like this you can see the amount of years that have passed on all projects:

How to Calculate Years in Excel from Today

For a future date, you have to enter the arguments in reverse order in the DAYS function.

  • Insert the following formula in an empty cell.
=DAYS(C14,NOW())/365
  • After pressing ENTER, you will get the years between today’s date and the indicated future date.

Calculate Years of a Future Date in Excel from Today

  • If you drag cell D14 to the end of your dataset, you will get the calculations for all other upcoming projects.

Finding the Remaining Years from Today for Upcoming Projects

Read More: How to Calculate Years Between Two Dates in Excel


Method 2 – Simple Formula to Calculate Years from Today in Excel

  • Copy the following formula to an empty cell:
=(E6-C6)/365

The above formula finds the difference between the dates in years provided in cells E6 and C6. We are dividing the result by 365 to find the difference in years.

  • After pressing ENTER, you will get the years between the starting date and today’s date (we were preparing the tutorial on 18 November 2021).

Generic Formula to Calculate Years in Excel from Today

  •  Then, for all other current projects, you can calculate the years in a similar manner.

Copy Generic Formula to Other Cells

For a future date, you have to enter the cells in reverse order in the subtraction formula.

  • Copy the following formula to an empty cell.
=(C14-E14)/365
  • After pressing ENTER, you will get the years between today’s date and the future date.

Generic Formula to Calculate Remaining Years in Excel for Upcoming Projects

  • If you now drag cell D14 to the end of your dataset, you will get the calculations for all other upcoming projects.

Calculate Remaining Years in Excel for Upcoming Projects

Read More: Excel Formula to Calculate Number of Days Between Today and Another Date


Method 3 – Using TODAY Function to Compute Years from Today

  • Copy the following formula to an empty cell.
=(TODAY()-C6)/365

The TODAY function provides the current date and the formula finds the difference between today’s date and the provided date in cell C6.

Using TODAY Function to Calculate years from Today in Excel

  • After pressing ENTER, you will get the years between the starting date and today’s date. You can calculate the years for all other current projects in a similar manner.

How to Calculate Years in Excel with TODAY Function

To calculate years between a future date and today’s date, you have to first enter the starting date in your formula.

  • Copy the following formula.
=(C14-TODAY())/365
  • After pressing ENTER, you will get the years between today’s date and the future date.

How to Calculate Remaining Years in Excel with a Future Date

  • Drag cell D14 to the end of your dataset to find the calculations for all other upcoming projects.

Using TODAY Function for Upcoming Projects

Read More: How to Count Months from Date to Today by Using Excel Formula


Method 4 – Using the NOW Function to Calculate Years from Today in Excel

  • Copy the following formula to an empty cell.
=(NOW()-C6)/365

The NOW function provides the current date (time), and the formula finds the difference between today’s date and the provided date in C6.

  • After pressing ENTER, you will get the years between the starting date and today’s date.

Using NOW Function to Compute Years from Today

  • You can calculate the years for all other current projects in a similar manner.

Use of NOW Function in all the Cells

To calculate years between a future date and today’s date, you have to enter the starting date first in your formula.

  • Use the following formula:
=(C14-NOW())/365
  • After pressing ENTER, you will get the years between today’s date and the future date.

Calculate Years for a Future Date Using NOW Function

  • Drag cell D14 to the end of your dataset to find the calculations for all other upcoming projects.

Calculate Remaining Years from Today to a Future Date


Practice Section

Now you can practice using those methods by yourself.

Practice Section to Calculate Years in Excel from Today


Download Practice Workbook


Further Readings


<< Go Back to Days Between Dates | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Prantick Bala
Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo