How to Add Days to Date Using Excel Formula (5 Easy Ways)

Watch Video – Add Days to Date Using Excel Formula

Date Basics in Excel

If we need to add dates to Excel, we can enter the numbers and format them into different dates. Excel’s default date format is m/dd/yyyy (6/20/2021). We may tailor it to our specific requirements.

Select the cells of the Long Dates
Go to the Home tab from Ribbon.
Click on the drop-down icon.
Choose the Long Date option from the drop-down.

excel formula add days to date

The Long Date format will be applied as shown in the image below.

5 Simple Methods to Add Days to Date Using Excel Formula

Method 1 – Adding 2 Cells to Add Days to Date in Excel

Steps:

Enter the following formula in cell D5.

=B5+C5

Cell B5 represents the cells of the Dates column and cell C5 refers to the cells of the Days (+/-) column.

Press ENTER.

You will get the updated Promotion Dates in cell D5.

Use AutoFill to fill in the remaining cells.

Final output of method 1to add days to date using Excel formula

Method 2 – Using DATE Function

The sample dataset “Project Deadlines” will be used for illustration.

Using DATE Function to add days to date using Excel formula

Steps:

Enter the following formula in cell F5.

=DATE(B5,C5,D5+E5)

Cell B5 indicates the Year, cell C5 represents the Month, cell D5 refers to the Day and cell E5 indicates the number of days that are to be added.

Press ENTER.

You will get the following output in cell F5.

Use AutoFill to fill in the remaining cells.

Final output of method 2 to add days to date using Excel formula

Method 3 – Utilizing Paste Special Feature of Excel

The sample dataset “New Promotion Dates” will be used for illustration.

Utilizing Paste Special Feature to add days to date using Excel formula

Steps:

Select the cells of the Dates column and copy the cells.

Click on cell D5 and paste the copied cells in the Promotion Dates column.

Select cell C5 and press CTRL + C.

Select the cells of the Promotion Dates
Go to the Home tab from the Ribbon.
Select the Paste option.
Choose the Paste Special option from the drop-down.

Using Paste Special Feature to add days to date using Excel formula

The Paste Special dialogue box will be available on your worksheet.

Choose the Values option under the Paste section.
Select the Add option under the Operation section.
Click OK.

10 days are added in the Promotion Dates column, as shown in the following image.

Final output of method 3 to add days to date using Excel formula

Method 4 – Employing Combination of YEAR, MONTH, and DAY Functions

Steps:

Enter the following formula in cell D5.

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

Cell B5 represents the cell of the Dates column and cell C5 refers to the number of days that need to be added.

Press ENTER.

Employing Combination of YEAR, MONTH, and DAY Functions to add days to date using Excel formula

The specified number of days will be added and you will have the output in cell D5.

Use AutoFill to fill in the remaining cells.

Final output of method 4 to add days to date using Excel formula

Method 5 – Using VBA Macro to Add Days in Excel

Steps:

Go to the Developer tab from the Excel Ribbon.
Click on the Visual Basic option from the Code group.

Using VBA Macro to Add Days in Excel to add days to date using Excel formula

The Microsoft Visual Basic window will open on your worksheet.

Go to the Insert tab in the Microsoft Visual Basic window.
Select the Module option from the drop-down.

Inserting module to add days to date using Excel formula

Enter the code below in the blank Module.

Sub Add_Day_To_Date()

Dim x As Range

For Each x In Selection.Cells
x.Value = x.Value + 1
Next x

End Sub

Code Breakdown

We initiated a sub procedure named Add_Day_To_Date.
Declared a variable x as Range.
Used the For Next loop for each value of x of the selected range.
Increase the value of x by 1 and reassigned it to x.
Terminated the For Next loop.
Ended the sub procedure.

Click on Save.

Press the keyboard shortcut ALT + F11 and you will be redirected to the worksheet.
Copy and paste the cells of the Dates column into the Updated Dates column.