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.