< Go Back

Add days to date

How to add days to date in excel

Do you want to learn how to add days to a date? This post will give you an overview of how to use formula functions to be able to add days to a date. This way you can calculate the exact date you will land after spending days doing a certain task. How does excel make adding days to date a simple job?

Figure 1. Add days to date example datasheet

Formula

=B4+C4

Explanation

The way excel manages dates is by assigning them numbers and using certain formulas you can either add or subtract values to said numbers to make calculations with them. Excel automatically translates numbers into dates so you can read them as such, this way you can add days to date without much effort.

Example

For example, the date 1-Jan-2000 can be read as 36526, if you add 4 to it, this number becomes 36530 which can be read as 5-Jan-2000.

Let’s use the data sheet shown before as another example. Dates were put normally on row B, the days that were to be added or subtracted were put on row C and the formulas to add days to date were put on row D. On the first date which reads as 10-Oct-2018 we added 5 days.

Figure 2. Add days to date sample number

=B4+C4

=43383+5

=43388

And when the number 43388 is turned into a date, it becomes 15-Oct-2018.

Figure 3. Add days to date results

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar