ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Formula > How to Add Days, Weeks, Months and Years to a Date in Excel

How to Add Days, Weeks, Months and Years to a Date in Excel

How to add days, weeks, months and years to a date in Excel?
Table of contents :
  • How to add DAYS to a date in Excel?
  • How to add WEEKS to a date in Excel?
  • How to add MONTHS to a date in Excel?
  • How to add YEARS to a date in Excel?
  • How to add YEARS, MONTHS, DAYS to a date in Excel?

How to add days, weeks, months, years to date in Excel

How to add DAYS to a date in Excel

Excel stores date value in integer number, to find out n days after a date, add the date and number of days.

Add days to date

The Result

Add days to date

The formula in cell B2 adds a date in cell A2 with number 20. The result, 20 days after May 16, 2019, is June 5, 2019.

There are many ways to get a date value, for the first formula the date value is inserted in a cell, the second formula uses the DATE function then added to the number 20. The result is the same as the first formula.

The third formula uses the TODAY function, this function returning a different date depending on what date it is today. Incidentally, today is May 16, 2019 add number 20 the result is the same as the two previous formulas.

Read the article below for a more detailed explanation of how Excel stores date and time value.

  • How Excel Stores Date and Time in Excel

How to add WEEKS to a date in Excel

To find out n weeks after a date, use the addition and multiplication formula. The multiplication formula used to convert weeks into days by multiplying by 7. The addition formula used to add the results of the multiplication formula with a date. The result is n weeks after a date.

Add weeks to date

The result

Add weeks to date

1 week after May 16, 2019, is May 23, 2019, and 4 weeks after May 16, 2019, is June 13, 2019.

You can use negative numbers to find n weeks before a date. The result of the formula in cell C3 shows that May 2, 2019, is 2 weeks before May 16, 2019.

Why does the formula using an absolute reference? Read the article below for a full explanation.

  • All About Excel Cell Reference

How to add MONTHS to a date in Excel

How to add months to a date is different by adding days/weeks to a date.

The first step to do is to extract the year, month, and day of date by using the YEAR, MONTH, and DAY functions. To add n months after a date, add the n value to the MONTH function result, then arrange them all with the DATE function to find out the date after n months.

Add months to date

The result

Add months to date

1 month and 3 months after May 16, 2019, are June 16, 2019, and August 16, 2019, while 2 months and 5 months before May 16, 2019, are March 16, 2019, and December 16, 2019.

You got the same date even though several months have different days.

How to add YEARS to a date in Excel

To get n years after a date is like to get n months after a date. You must extract the date value using the YEAR, MONTH, and DAY functions.

Add the YEAR function result by to the desired n year value, then arrange them all with the DATE function.

Add years to date

The result

Add years to date

You got the same date and month, the different only in year value.

How to add YEARS, MONTHS, DAYS to a date in Excel

What date is 1 year 4 months 17 days after May 16, 2019?

The first step is to extract the date value using the YEAR, MONTH, and DAY functions.

The second step, add number 1 to the YEAR function result, add number 4 to the MONTH function result and add number 17 to the DAY function result.

The third step arranges all in the DATE function.

The formula

=DATE(YEAR(A2)+B2,MONTH(A2)+C2,DAY(A2)+D2)

The result

Add years, months, weeks, days to date

1 year 4 months 17 days after May 16, 2019, is Oct 3, 2020.

**

What date are 2 years 10 months 5 days before May 16, 2019?

The formula

=DATE(YEAR(A2)+B2,MONTH(A2)+C2,DAY(A2)+D2)

The result

Add years, months, weeks, days to date

The formula is the same as the previous formula. Use negative numbers to find out the date before a date.

2 years 10 months 5 days before May 16, 2019, is July 11, 2016.

Related Function

Function used in this article
  • Excel DATE Function
  • Excel YEAR Function
  • Excel MONTH Function
  • Excel DAY Function
Usefull links
  • Microsoft Excel Add or Subtract a dates documentation
Share
Tweet
Google+
Email
Prev Article
Next Article

Related Articles

Combine Separate First and Last Name in Excel
How to Combine First and Last Name in Excel How …

How to Combine and Separate First and Last Name in Excel

Excel provides three different functions to extract a day, month, …

How to Extract Day, Month and Year from Date in Excel

VLOOKUP NA Error
VLOOKUP NA error is the most common error when using …

VLOOKUP NA Error – Causes and Solutions

SUMPRODUCT IF
There is no SUMPRODUCTIF function in excel, but you can …

SUMPRODUCT IF – Multiple Criteria SUMPRODUCT

SUMIFS Limitations and Solutions
“How to Use the Excel SUMIFS Function” article explains SUMIFS …

SUMIFS Limitations and Solutions

Tags:3 Months from today Date 30 Days from Date 30 Months from today 45 Days from Date 6 Months from Date Add Days to Date Add Months to Date Add Weeks to a Date in Excel Add Weeks to Date Add Years to Date Add Years to Date in Excel Calculate 6 Months from a Date DATE Function Day Function Days from Date Excel Add Days to Date Excel Add Months to Date Excel Add Weeks to Date Excel Formula Add Days to Date Excel Formula to Add Months to a Date Excel Formula to Add Years to a Date Excel How to Add Days to a Date How to Add Days in Excel How to Add Days to a Date in Excel How to Add Days to Date in Excel How to Add Months in Excel How to Add Months to a Date in Excel How to Add Weeks to a Date in Excel How to Add Years in Excel How to Add Years to a Date in Excel Month Function Subtraction Formula Year Function

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2023 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh