Microsoft Excel Functions & Formulas

Use the EDATE function to calculate months

If a few months have to be added to or subtracted from a date, the

EDATE function is very useful. This function returns a serial num-

ber that represents the date that is the indicated number of months

before or after a specified date (offset).

In this example, column A of a worksheet contains the start

dates. In column B, enter the offset in months to be added or sub-

tracted. The result should show up in column C.

4

To use EDATE and add or subtract a number of months to

start dates:

1. Enter different start dates in column A.

2. Enter offset months in column B.

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