Add a Specific Number of Days to a Date in Excel

July 2016


Microsoft Excel is capable of performing thousands of different types of data manipulations and calculations that go far beyond professional mathematical purposes. For example, did you know that you can calculate specific dates in the past and future with one simple spreadsheet manipulation?

This article will teach you how to use Excel formulas to add a specific number of days to a date.

Formula to Calculate Dates in Excel

Please note that depending on your region of the world, the date formats used may appear differently (DD/MM/YYYY vs. MM/DD/YYYY). Regardless of the format used, the formula should remain the same.


Let's assume it's January 3, 2016 and you'd like to know what date it will be 25 days from now. Enter 01/03/2016 into column A1.

Next, in column B1, type in the formula =SUM (A1+25).

Format column B1 as a date. Upon hitting enter, field B1 should read 01/28/2016.

See also :

This document entitled « Add a Specific Number of Days to a Date in Excel » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.