Add a Specific Number of Days to a Date in Excel

April 2017

Microsoft Excel is capable of performing thousands of different types of data manipulations and calculations that go far beyond professional mathematical purposes. For example, the software has the capability to calculate specific dates in the past and future with just 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.


Published by aakai1056. Latest update on August 8, 2016 at 06:38 AM by ChristinaCCM.
This document, titled "Add a Specific Number of Days to a Date in Excel," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (