Returns the serial number of the date that is the indicated number of months before or after the start date.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
EDATE(start_date, months)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)Kết quả: 2023-03-15
Adds 2 months to January 15, 2023.
=EDATE("2023-05-31", -1)Kết quả: 2023-04-30
Subtracts 1 month from May 31, 2023, resulting in the last day of April.
You may need to change the cell format to 'Date' in the Number group on the Home tab.