How To Add One Day To A Date In Excel

How to add or subtract days, months, and years to date in Excel?

This article provides seven solutions to add or subtract days, weeks, months, years, or a combination of years/months/days to a date in Excel. Video Demo

Add together or decrease days to engagement with formula
Add or subtract days to multiple dates without formula
Add or subtract weeks to date in Excel
Add together or subtract months to appointment in Excel
Add or subtract years to date in Excel
Add or decrease a combination of years, month, and days to date in Excel
Add or subtract days, weeks, months, or years to date with Kutools for Excel

Add together or subtract days to date with formula

You may have noticed that dates are five-digit numbers in Excel. Therefore, yous tin can add or decrease days as easy as adding or minus the number of days in Excel.

= date + number of days

i. Select a bare jail cell y'all volition identify the calculating result, type the formula =A2+x, and press the Enter central.
Notation: For subtracting 10 days from the date, please utilize this formula =A2–ten.

2. If you need to apply this formula to other cells, please drag the AutoFill handle of the formula cell to these cells as y'all demand.

Now you have added or subtracted the same number of days from these dates in bulk. Come across screenshot:

Add or subtract days to multiple dates without formula

Comparing to formulas, some Excel users prefer to add or decrease days directly without formulas. Hither I will guide you to add together or subtract the aforementioned number of days from multiple dates with Paste Special characteristic in Excel.

ane. Blazon the number of days you will add together or subtract to dates in a blank cell, says 10, and then re-create information technology. See screenshot:

ii. Select the dates you will add or decrease days, right click, and select Paste Special > Paste Special in the context bill of fare. See screenshot:

3. In the Paste Special dialog, please check Add together or Decrease options every bit you need, and click the OK button. See screenshot:

4. At present the number is added or subtracted to the dates, and the dates display as 5-digit numbers. Continue these 5-digit numbers selected, and click Domicile > Number Format box > Curt Date to catechumen them to dates again.

Now you will see the specified number of days is added or subtracted from the specified range of dates in majority without formula. See screenshot:

Add or subtract weeks to date in Excel

You lot can also apply formula to add or subtract the specified number of weeks from a date in Excel. Delight do as follows:

= date + vii * number of weeks

ane. Select the blank cell you volition place the calculating result, type the formula =A2+4*7, and printing the Enter key.
Note: For subtracting 4 weeks from the date, please apply this formula =A2-4*7.

Kutools for Excel

Stand out from the Crowd

300 Handy Tools
Solve eighty% Issues in Excel

Free Trial Now

Say goodbye to terrible VBA and formulas!

2. If yous need to add or subtract weeks from other dates, please drag the AutoFill handle of the formula cell equally you need.

At present yous have added or subtracted the same number of weeks from multiple dates in bulk. See screenshot:

Add together or subtract months to date in Excel

For adding or subtracting months to dates, it'southward not fit to add or subtract 30 from the dates considering months comprise different number of days in a year, some comprise thirty days, some incorporate 31 days, while some contain 28 or 29 days. Therefore, we need to utilize the EDATE part to deal with this state of affairs.

= EDATE(date, number of months)

1. Select the blank jail cell you volition place the calculating result, type the formula =EDATE(A2,iii), and elevate this formula cell'due south AutoFill handle to apply this formula to other cells as you need.
Notation: To subtracting three months from the date, please utilise this formula =EDATE(A2,-3).

2. As you see, the EDATE office will return 5-digit numbers. Delight keep these 5-digit numbers selected, and click Home > Number Format box > Brusk Appointment to convert them to dates back. See screenshot:

Now you lot will encounter information technology has added or subtracted the same number of months to the dates in bulk. See screenshot:

Add together or subtract years to date in Excel

For example, yous will add half-dozen years to a batch of dates in Excel, yous can exercise as follows:

= DATE(Year(appointment) + number of years, Calendar month(date),DAY(appointment))

1. Select the blank jail cell you will identify the calculating result, type the formula =Engagement(YEAR(A2)+half-dozen,MONTH(A2),24-hour interval(A2)), and printing the Enter key.
Note: To decrease 6 years from the date, please apply this formula =DATE(YEAR(A2)-half-dozen,Month(A2),DAY(A2)).

ii. If needed, drag the formula cell'south AutoFill handle to apply this formula to other cells every bit y'all need.

Add or decrease a combination of years, calendar month, and days to date in Excel

In some cases, you may demand to add or decrease years, months, and days at the aforementioned time, says add together three years 5 months and 15 days. In this case, you can utilize the Appointment role to solve the trouble.

= DATE(Twelvemonth(appointment) + number of years, MONTH(appointment) + number of months, Twenty-four hours(engagement) + number of days)

i. Select the blank cell you will place the computing result, blazon the formula =DATE(YEAR(A2)+3,MONTH(A2)+5,Day(A2)+fifteen), and press the Enter key. Come across screenshot:
Note: To subtract the combination of years, months, and days together, please apply this formula =Appointment(YEAR(A2)-3,Calendar month(A2)-5,Day(A2)-15).

two. If needed, delight drag this formula cell's AutoFill handle to apply this formula to other cells.

Add or subtract days, weeks, months, or years to date with Kutools for Excel

If you lot have Kutools for Excel installed, you lot volition find its Formula Helper lists nearly-commonly-used formulas to assist you easily calculate in Excel, including adding days, weeks, months, or years to date. Please practise as follows:

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature gratuitous trial xxx-day, no credit menu required! Go It Now

1. Select the prison cell you will put calculating event in, and click Kutools > Formula Helper > Add years to date.
Tip: Please select the suitable formula from the Formula Helper drop downward list based on your needs. For case, select Add weeks to date for adding/subtracting specified weeks to a date.

2. In the opening Formula Helper dialog box, specify the date jail cell accost in the Date Time box, and blazon the number of years you will add together in the Number box.
Tip: In our instance, we will add 5 yr from the appointment, therefore we type v into the Number box. If you demand to subtract some years, for example 3 years, delight type -iii into the Number box.

3. Click the Ok button to employ the formula of Add years to date. Please elevate the Fill Handle to apply this formula to other range if necessary.

Add/subtract days to date:

Add/subtract weeks to date:

Add/decrease months to appointment:

Kutools for Excel'southward Formula Helper will save Excel users from memorizing complicate formulas and lists most common-used formulas to help y'all quickly summate and solve issues in Excel, says Add years / months / weeks / days to appointment, Add hours / minutes / seconds to date, etc. Have a Complimentary Trial!

Demo: Add or subtract days, weeks, months, or years to engagement in Excel

300 tools help you stand out from the crowd at present

with Kutools for Excel - never worry most chore cut

Kutools for Excel brings 300 handy tools for 1500 piece of work scenarios, helps you work faster and improve than your colleagues, and easily win trust of your boss. You will exist the terminal i in the list of layoffs, and easily maintain a stable and ameliorate life for your family!

To exist a master of Excel in iii minutes, and hands win appreciation of others.
Improve 80% piece of work efficiency, solve your lxxx% problems in Excel, not work overtime.
Speed upwards your work, salve 2 hours every day to improve yourself and back-trail family.
Say goodbye to complicated formulas and VBA code, gratis up your retentiveness.
Reduce thousands of keyboard operations and mouse clicks, far abroad from mouse paw.
Spend $39.0, worth more $4000.0 grooming of others.
Choice of 110,000+ highly effective people and 300+ famous companies, piece of work stable in Excel.
Total feature gratuitous trial 30-day, no credit carte du jour required.