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

Lookup and Reference Examples

  • How to get first column number in range in Excel
  • How to use Excel TRANSPOSE Function
  • Approximate match with multiple criteria in Excel
  • Merge tables with VLOOKUP in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • Get column index in Excel Table
  • Excel Pie Chart
  • How To Create Pareto Chart in Excel
  • Conditional Formatting Data bars Examples in Excel
  • Error Bars in Excel

Data Validation Examples

  • How To Create Drop-down List in Excel
  • Excel Data validation only dates between
  • Excel Data validation must begin with
  • Excel Data validation specific characters only
  • Excel Data validation don’t exceed total

Add months to date in Excel

by

It you need to add months to date in Excel then this tutorials is for you. See example below:

To add a given number of years to a date, you can use the EDATE function.

Worked Example:   How to get same date next year or previous year in Excel

Formula

=EDATE(date,months)

Explanation

In the example shown, the formula in D5 is:

=EDATE(B5,C5)

How this formula works

The EDATE function is fully automatic. Simply supply a valid date and a number of months and EDATE will return a new date. To subtract months from a date, supply a negative value.

Worked Example:   Add years to date in Excel

Adding years

To move forwards and backwards in years from a certain date, you can multiply by 12 inside EDATE like this:

=EDATE(A1,12*10) // 10 years
=EDATE(A1,12*50) // 50 years

 

Worked Example:   How to calculate future date say 6 months ahead in Excel

Post navigation

Previous Post:

Add workdays no weekends in Excel

Next Post:

Add decimal minutes to time 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
  • How to count specific characters in a cell in Excel
  • TEXT function: Description, Usage, Syntax, Examples and Explanation
  • How to use double quotes inside a formula in Excel
  • Get position of 2nd 3rd and more instance of character in Excel
  • Remove text by variable position in a cell in Excel
  • Convert date to Julian format in Excel
  • Pad week numbers with zeros in Excel
  • Convert text to date in Excel
  • Convert date to text in Excel
  • Get days before a date in Excel
  • Calculate interest for given period in Excel
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles