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:
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.