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:
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.
Step 1: Enter the formula in the D4 cell.
= B4+C4
Step 2: 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.
Step 1: Enter the formula in E4.
=DATE (B4, C4, D4)
Step 2: Â 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.
Step 1: Enter the formula in the E4 cell.
=WORKDAY(C4, D4)
Step 2: Â 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.
Step 1: Right-click on cell C4 and select the Copy option or use the keyboard shortcut Ctrl+C.Â
Step 2: Select the Dates cells.
Step 3: Right-click on it and select Paste Special or use the keyboard shortcut.
Alt >> E >> S
Step 4: Then follow the steps:
- Select the Values option.
- Â Then select the Add option.
- After that, click on the OK button.
Step 5: Then all the dates will be increased by 5.
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
- How to Add Months to a Date in Excel (2 Ways)
- How to Add 30 Days to a Date in Excel (7 Quick Methods)
- Excel Add Months to Date (4 Easiest Examples)
- Add Weeks to A Date in Excel [4 Fast & Simple Methods with Template]
- How to Add 7 Days to a Date in Excel (3 Methods)
- How to Calculate Overdue Days in Excel (using Functions)
- How to Add/Subtract Years to a Date in Excel
- Add days to date in Excel excluding weekends and holidays (4 ways)