Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Left Lookup in Excel
  • Count unique text values with criteria
  • Last row number in range
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Find closest match in Excel

Data Analysis Examples

  • How to perform a t-Test in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How to count table rows in Excel
  • Chart Axes in Excel
  • Get column name from index in Excel Table

Data Validation Examples

  • Excel Data validation specific characters only
  • Excel Data validation no punctuation
  • Excel Data validation allow weekday only
  • Excel Data validation must begin with
  • Excel Data validation exists in list

Add years to date in Excel

by

If you need to add years to date in Excel then this tutorials is for you. See the example below .

To add a given number of years to a date, you can use a formula based on the DATE function, with help from the YEAR, MONTH, and DAY functions.

Worked Example:   DATE function: Description, Usage, Syntax, Examples and Explanation

Formula

=DATE(YEAR(date)+years,MONTH(date),DAY(date))

Note: if you need to add an “even” multiple of 12 months to a date (i.e. 12, 24, 36, 48, etc) you can use a much simpler formula based on the EDATE function.

Explanation

In the example shown, the formula in D5 is:

=DATE(YEAR(B5)+C5,MONTH(B5),DAY(B5))

How this formula works

Working from the inside out, the YEAR, MONTH, and DAY functions extract those respective date components:

=YEAR(B5) // 1960
=MONTH(B5) // 3
=DAY(B5) // 8

At the outer level, the DATE function simply reassembles the component values back into a valid Excel date. To add years to the date, we just need to add the value in C5 to the year component prior to reassembly:

=DATE(YEAR(B5)+C5,MONTH(B5),DAY(B5))

The formula is then solved like this:

=DATE(1960+10,3,8)
=DATE(1970,3,8)
=8-Mar-1970
Worked Example:   Highlight rows with dates between In Excel

Post navigation

Previous Post:

Assign points based on late time in Excel

Next Post:

Add workdays to date custom weekends in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • REPT function: Description, Usage, Syntax, Examples and Explanation
  • How to count specific words in a cell in Excel
  • How to count number of characters of text in a cell in Excel
  • Extract most frequently occurring text in Excel
  • How to extract last two words from text string in Excel
  • Get days between dates ignoring years in Excel
  • How to calculate working days left in month in Excel
  • How to get Weekdays, Working days between Two Dates in Excel
  • Display Date is same month in Excel
  • Convert Excel time to Unix time in Excel
  • Future value vs. Present value examples in Excel
  • DB function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan principal payments in Excel
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles