Returns the serial number of the date that is the indicated number of months before or after the start date.
Sintassi
EDATE(start_date, months)Argomenti
start_dateobbligatorio
A date that represents the starting date.
monthsobbligatorio
The number of months before or after the start_date; use a negative value for past dates.
The EDATE function is used to calculate maturity dates or due dates that fall on the same day of the month as the start date. It automatically adjusts for variations in the number of days in different months.
=EDATE("2023-01-15", 2)→2023-03-15Adds 2 months to January 15, 2023.
=EDATE("2023-05-31", -1)→2023-04-30Subtracts 1 month from May 31, 2023, resulting in the last day of April.
Select the cell
Click on the cell where you want to display the calculated date.
Enter the formula
Type =EDATE( and select the start date cell, followed by the number of months, then press Enter.
You may need to change the cell format to 'Date' in the Number group on the Home tab.