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

Though in Excel there is no inbuilt function to calculate the years between a past or future date and today’s date, you can do the task by applying the combination of some simple functions. In this article, I’ll show you four ways by which you will be able to calculate years in Excel from Today.

As an illustration, we have the starting date of some current and upcoming projects of a company. Now we will calculate the years passed till today for the current projects and the years remaining to start from today for the future projects.

DATASET

Download Practice Workbook

4 Ways to Calculate Years in Excel from Today

1. Calculate Years from Today Using DAYS Function

You can calculate years from today by using the DAYS function. Type the following formula in an empty cell,

=DAYS(NOW(),C6)/365

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

Calculate years from today

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

DAYS FUNCTION

For a future date, you have to enter the arguments in reverse order in the DAYS function. Type the following formula in an empty cell,

=DAYS(C14,NOW())/365

Calculate years from today

After pressing ENTER, You will get the years between Today and the future date.

DAYS FUNCTION

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

days function

2. Simple Formula to Calculate Years from Today

Another easy way to calculate years from today is to use a simple subtraction formula. Type the formula in an empty cell,

=(E6-C6)/365

Here, the formula finds the difference between the dates provided in cells E6 and C6. We are dividing the result by 365 to find the difference in year.

Calculate years from today

After pressing ENTER, You will get the years between the starting date and today (We were preparing the tutorial on 18 November 2021). For all other current projects, you can calculate the years in a similar manner.

formula in excel

For a future date, you have to enter the cells in reverse order in the subtraction formula. Type the following formula in an empty cell,

=(C14-E14)/365

Calculate years from today

After pressing ENTER, You will get the years between Today and the future date.

formula in excel

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

formula in excel

3. Calculate years from today Using TODAY Function

Using the TODAY function is another way to calculate years between today and any other date. Type the following formula in an empty cell,

=(TODAY()-C6)/365

Here, the TODAY function provided the current date, and the formula finds the difference between today and the provided day in C6.

Calculate years from today

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

Today function

For calculating years between a future date and today, you have to enter the starting date first in your formula. Type the following formula,

=(C14-TODAY())/365

Calculate years from today

After pressing ENTER, You will get the years between Today and the future date.

TODAY FUNCTION

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

TODAY FUNCTION

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

4. Calculate years from today Using NOW Function

Using the NOW function for calculating years from today is quite similar to the TODAY function. Type the following formula in an empty cell,

=(NOW()-C6)/365

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

Calculate years from today

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

now

For calculating years between a future date and today, you have to enter the starting date first in your formula. Type the following formula,

=(C14-NOW())/365

Calculate years from today

After pressing ENTER, You will get the years between Today and the future date.

NOW FUNCTION

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

CALCULATE YEARS USING NOW FUNCTION

Conclusion

You can calculate the years from today in Excel by using any of the described methods. If you have any confusion or face any problems regarding any of the methods, please leave a comment.


Further Readings

Prantick

Prantick

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo