EDATE Function in Excel

 

EDATE(start_date, months)

The EDATE function is an Excel formula used to add or subtract a specific number of months from a given starting date. The syntax for the EDATE function is EDATE(start_date, months), where:

1. start_date: the starting date from which you want to add or subtract months. It can be a reference to a cell that contains a date, or a date entered directly into the formula using quotation marks and a date format such as "mm/dd/yyyy".
2. months: the number of months that you want to add or subtract from the start date. This argument can be a positive or negative integer, depending on whether you want to add or subtract months from the start date.
3. For example, if the start date is January 1, 2023 and you want to add three months, the formula would be =EDATE("01/01/2023", 3), which would return April 1, 2023. If you want to subtract three months from the same start date, the formula would be =EDATE("01/01/2023", -3), which would return October 1, 2022.

The EDATE function is useful when you need to calculate dates that are a specific number of months in the future or past, such as due dates for payments or contracts, or the expiration date of a subscription.