Use the EDATE function to calculate months - Date and Time Functions - Microsoft Excel Tutorials

Use the EDATE function to calculate months using Microsoft Excel

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 number 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 subtracted. The result should show up in column C.

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:
=EDATE(A2,B2).
4. Press <-Ctrl+Enter->.

Use the EDATE function to calculate months using Microsoft Excel

Note: To use the EDATE function, the Analysis ToolPak add-in has to be installed as described in the previous example.