Calculate the date a specific number of years from today using the calculator below.

← 4 years from today6 years from today →

On this page

How to Calculate the Date Several Years From Today

If you’re planning long-term goals, future events, or major projects, you may need to determine what the date will be a certain number of years from today. There are a couple of reliable ways to calculate it.

Method One: Manual Calculation

The simplest way to estimate a date several years from now is to use a calendar.

  1. Start with today’s date.
  2. Move forward one year at a time, counting each year until you reach the desired number.
  3. When moving through leap years, keep in mind that February 29 affects date alignment. For example, if you start on Feb 29 and move to a year without a leap day, the result typically becomes Feb 28 or Mar 1, depending on the convention used.

This method works well for calculating dates just a few years ahead, but it becomes more cumbersome as the number of years increases. For instance, finding the date 20 years from today requires tracking leap years and month lengths over two decades.

Method Two: Using Spreadsheet Software

A much faster and more accurate method is to use Microsoft Excel or Google Sheets.

  • Enter your starting date into any cell — for example, A1.
  • In another cell (e.g., B1), use this formula to add 5 years to the date in A1:
=EDATE(A1, 5 * 12)

This works because the EDATE function adds months, so multiplying the number of years by 12 gives the correct number of months. For this example, 5 years × 12 months = 60 months.

The result in B1 will show the date five years from the start date.

To calculate a different number of years, simply replace 5 with the number of years you need, or replace A1 if your date is stored in a different cell.