Excel Guides

The EDATE Function in Excel

The EDATE function in Excel returns the date that is a specified number of months before or after a given date. The function takes two arguments: the start date and the number of months to add or subtract. You can use the EDATE function to calculate expiration dates, maturity dates, and other events that occur at regular intervals.

To use the EDATE function, enter the start date in a cell, then enter the number of months to add or subtract in another cell. For example, if the start date is in cell A1 and the number of months is in cell A2, you would enter the following formula in cell A3:

=EDATE(A1,A2)

If you want to subtract months instead of adding them, you can use a negative number for the second argument. For example, to subtract 3 months from a date in cell A1, you would use this formula: =EDATE(A1,-3)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.