Page 11 of 16PREVNEXT

Learn how to figure out dates using formulas in Excel 2007

Using the DATE function to find a date after a number of months

Callout 1 Formula in the worksheet.
Callout 2 Formula result.
Callout 3 Formula in the formula bar.

Say that you have about 25 months from 6/9/2011 to complete a project, and you need to find the project end date. You could do that by using the DATE function. The DATE function has three arguments: year, month, and day.

In our example, after entering 25 in cell B2, you would type this formula in cell A4:

=DATE(2011,6+B2,9)

2011 is the year argument, 6 plus the value in cell B2 is the month argument, 9 is the day argument. Commas separate the arguments, and parentheses enclose all the arguments.

The project ends on 7/9/2013. Because you typed the cell reference (B2) instead of the value in that cell (25), Excel can automatically update the result if the value changes. For example, if the time period changes from 25 months to 23 months, you could get the revised date 5/9/2013 by changing the value in cell B2 from 25 to 23, without retyping the formula.

Page 11 of 16PREVNEXT