Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Add days to date in Excel

It you need to add days to date in Excel then this tutorials is for you. See example below:

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:


How this formula works

Dates in Excel are just serial numbers. The number 1 represents January 1, 1900, the number 1000 is September 26, 1902, and so on.

Also See:   EDATE function: Description, Usage, Syntax, Examples and Explanation

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:


In the example shown, the formula is solved like this:


Recall, Excel saves dates as number so when formatted as a date, 36868 is December 8, 2000.

Also See:   How to get same date next month or previous month in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *