=date+days

Related formulas

Add years to date

Add months to date

To add a given number of years to a date, you can use the EDATE function.

In the example shown, the formula in D5 is:

=B5+C5

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.

=date+days