There is no built-in function to calculate the years between a past or future date and today’s date in Excel. You can do the task by applying a 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. We will calculate the years passed till today for the current projects and the years remaining to start from today for future projects.
How to Calculate Years from Today in Excel: 4 Easy Ways
Now, I will demonstrate 4 suitable methods with detailed steps to calculate years from today, in the case of both current and upcoming projects in Excel. Furthermore, for this session, I’m going to use Microsoft Office 365 version.
1. Combining DAYS & NOW Functions to Find Years from Today
You can calculate years from today by using the DAYS function.
- Type the following formula in an empty cell.
=DAYS(NOW(),C6)/365Here, the NOW function provides the current time, and then the DAYS function calculates the difference between today and the provided day in cell C6.
- 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. Also, you can use the Fill Handle icon to copy the formula.
Lastly, you will see all the years.
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 and the future date.
- Now, if you drag cell D14 to the end of your dataset, you will get the calculations for all other upcoming projects.
Read More: Excel Formula to Calculate Number of Days Between Today and Another Date
2. Simple Formula to Calculate Years from Today in Excel
Another easy way to calculate years from today is to use a simple subtraction formula.
- Firstly, type the formula in an empty cell.
=(E6-C6)/365Here, the 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 a year.
- After pressing ENTER, you will get the years between the starting date and today (we were preparing the tutorial on 18 November 2021).
- Â Then, for all other current projects, you can calculate the years in a similar manner.
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- After pressing ENTER, you will get the years between today and the future date.
- Here, if you drag cell D14 to the end of your dataset, you will get the calculations for all other upcoming projects.
Read More: Calculate Number of Days between Two Dates with VBA in Excel
Similar Readings
- How to Calculate Number of Months Between Two Dates in Excel
- Excel Formula to Count Days from Date
- How to Calculate Tenure in Years and Months in Excel
- How to Calculate Average Tenure of Employees in Excel
3. Using TODAY Function to Compute Years from Today
Using the TODAY function is another way to calculate years between today and any other date.
- Put the following formula in an empty cell.
=(TODAY()-C6)/365Here, the TODAY function provides the current date, and the formula finds the difference between today and the provided day in cell C6.
- 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.
For calculating years between a future date and today, you have to enter the starting date first in your formula.
- Similarly, type the following formula.
=(C14-TODAY())/365- After pressing ENTER, you will get the years between today and the future date.
- Drag cell D14 to the end of your dataset to find the calculations for all other upcoming projects.
Read More: How to Apply Excel Formula to Count Days from Date to Today
4. Applying NOW Function to Calculate Years from Today in Excel
Using the NOW function for calculating years from today is quite similar to the TODAY function.
- First, type the following formula in an empty cell.
=(NOW()-C6)/365Here, the NOW function provides the current date (time), and the formula finds the difference between today and the provided day in C6.
- 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.
For calculating years between a future date and today, you have to enter the starting date first in your formula.
- In the same way, type the following formula.
=(C14-NOW())/365- After pressing ENTER, you will get the years between today and the future date.
- Lastly, drag cell D14 to the end of your dataset to find the calculations for all other upcoming projects.
Read More: Calculate Years and Months between Two Dates in Excel
Practice Section
Now you can practice using those methods by yourself.
Download Practice Workbook
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
- How to Calculate Remaining Days in Excel
- How to Calculate Overdue Days in Excel
- How to Calculate Working Capital Days in Excel
- How to Calculate Days Outstanding in Excel
- How to Calculate Expiration Date with Excel Formula
- How to Create a Day Countdown in Excel
- Excel Calculates Difference Between Two Dates in Days
- How to Find Number of Weeks Between Two Dates in Excel
- How to Count Months from Date to Today by Using Excel Formula
- How to Calculate 90 Days from a Specific Date in Excel
