Add Days to Date Using Excel Formula

Add Days to Date Using Excel Formula

For project planning or time management, we need to make a routine or schedule. Making time schedules, MS Excel provides different ways to add days to date. In this article, I am going to show how to add days to date using Excel Formula.

Download the Workbook

Date Basics in Excel:

If we need to add dates in Excel, we can input the numbers and format them into different dates. By default Excel’s date format is “m/d/yyyy” (6/20/2021). We can customize it according to our needs. We can change the date format like this:

Date Basics in Excel

4 Ways to Add Days to Date Using Excel Formula

1. Simple Addition Method in Excel

Let’s assume we have a dataset of employees with their current dates and promotion dates for showing this process. Now we need to calculate the promotion by adding the current dates with the remaining dates.

Simple Addition Method in Excel

Step 1: Enter the formula in the D4 cell.

= B4+C4

Enter the formula =B4+C4 in the D4 cell

Step 2: Copy down the formula up to D8.

Copy down the formula up to D8

2. How to Add Days to Date Using DATE Function

Another way of adding days to date is to use the DATE function. The syntax will be:

DATE(year,month,day)

We can easily add days using the third parameter. Let’s have a dataset of some dates, months, years.  Now we will form a date by combining them.

How to Add Days to Date Using DATE Function

Step 1: Enter the formula in E4.

=DATE (B4, C4, D4)

 Enter the formula =DATE(B4,C4,D4) in E4

Step 2:  Copy down the formula up to E9.

 Copy down the formula up to E9

3. How to Add Only Weekdays to a Date

At the time of making a project deadline, we sometimes need to consider weekdays as well. We can easily add weekdays in our deadlines or any dates in Excel simply using the WORKDAY function.

Let’s think of a dataset of some projects with their deadlines. Now we will calculate the deadlines after adding the weekends.

 How to Add Only Weekdays to a Date

Step 1: Enter the formula in the E4 cell.

=WORKDAY(C4, D4)

Enter the formula =WORKDAY(C4,D4) in E4 cell

Step 2:  Copy down the formula up to E8.

. Copy down the formula up to E8

4. How to Add Days to Dates in Excel Using Paste Special (With Shortcut)

For this process, we will add dates using the special paste option in Excel. Let’s consider a dataset of some dates. We will add dates with the given dataset and show all the updated dates in the same column. All the dates will be increased by 5 in the same column.

How to Add  Days to Dates in Excel Using Paste Special (With Shortcut)

Step 1: Right-click on cell C4 and select the Copy option or use the keyboard shortcut Ctrl+C

Right click on cell C4 and select the Copy option or use the keyboard shortcut Ctrl+C

Step 2: Select the Dates cells.

Select the Dates cells

Step 3: Right-click on it and select Paste Special or use the keyboard shortcut.

Alt >> E >> S

Right-click on it and select Paste Special

Step 4: Then follow the steps:

  1. Select the Values option.
  2.  Then select the Add option.
  3. After that, click on the OK button.
    Copy Paste special process

Step 5: Then all the dates will be increased by 5.

After copy paste special

Conclusion

These are the ways you can add dates to date in various ways. Here I have discussed different ways with relevant examples step by step. I hope these methods will help you to resolve this type of issue. If you face any problems applying these methods, feel free to let us know.


Further Readings

Md. Abdullah Al Murad

Hello! Welcome to my Profile. Currently, I am working and researching Microsoft Excel, and here I will be posting articles related to this. My last educational degree is BSc, and my program was Computer Science and Engineering from American International University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo