Microsoft Excel Functions & Formulas

Use the DATE function to add months to a date

Let’s say we want to add a number of months to a given start date.

In a new worksheet, list different start dates in column A. In col-

umn B, enter the number of months to be added to or subtracted

from the start date. Based on that data, the end date can be

calculated.

4

To add months to or subtract months from dates:

1. In cells A2:A10 list some start dates as shown in Figure

4-15.

2. List in cells B2:B10 the number of months to add or

subtract.

3. Select cells C2:C10 and type the following formula:

=DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2)).

4. Press <Ctrl+Enter>.

Note: To determine an end date in the past, put a ...