Explanation
Dates in Excel are just serial numbers. The number 1 represents January 1, 1900, the number 1000 is September 26, 1902, and so on.
When you have a valid date in Excel, you and just add days directly. Day values can be positive or negative.
For example, with a date in A1, you can add 100 days like so:
=A1+100
In the example shown, the formula is solved like this:
=B5+C5
=36861+7
=36868
When formatted as a date, 36868 is December 8, 2000.
Related formulas
Add years to date
In this example, the goal is to use a formula to add or subtract a given number of years ( n ) to a date. There are two main ways to go about this in Excel. The first method uses the YEAR, MONTH, and DAY functions to take apart the date into separate components: year , month , and day . Then it...
Add months to date
The EDATE function is fully automatic. Simply supply a valid date and a number of months and EDATE will return a new date. To subtract months from a date, supply a negative value. Adding years To move forwards and backwards in years from a certain date, you can multiply by 12 inside EDATE like this...
Related functions
DAY Function
The Excel DAY function returns the day of the month as a number between 1 to 31 from a given date. You can use the DAY function to extract a day number from a date into a cell. You can also use the DAY function to extract and feed a day value into another function, like the...
