Skip to main content

Excel Formula: Add years to date

doc add hours to time 7

In some cases, you may want to add a specific number of years to a date, but it cannot directly add number of years to a given date like adding days, such as, "2020/4/1"+4 returns 2020/4/5. Here in this tutorial, it provides a formula to quickly add years to date in Excel.

Generic formula:



Date: the date you used to add years.
Years: a number that represents the number of years you want to add to the given date. It can be positive or negative, the formula subtracts years while the argument years is negative.

Return value

Return a value in date format.

How this formula work

Here takes an instance to explain how the formula works in Excel. Adding number of years which is placed in cell C3 to the date in cell B3, please use below formula:


Press Enter key to get the end date.
doc add years to date 2


YEAR, MONTH and DAY functions separately get the year, month and day as relative integers from the given date.

Date function is used to create a date based on the given year, month, and day.

Sample File

doc sampleClick to download sample file

Relative Formulas

Relative Functions

The Best Office Productivity Tools

Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

  • One second to switch between dozens of open documents!
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations