How to Use EDATE and EOMONTH Function in Excel | Syntax of EDATE and EOMONTH |
we are going to explain how to use EDATE and the EOMONTH functions in Microsoft Excel. They are basically, both date and time functions.
1.EDATE is a function in Excel that returns the serial number of the date, which is the indicated number of months before and after the start date. The Edate function is used to calculate the maturity date and due date that falls on the month’s same date as the issued date. The formula for the Edate function is EDATE (start_date, months).
2.EOMONTH function returns the serial number of the last day of the month, that is, the number of months before or after the start_date. The EOMONTH function calculates the maturity date and due date that drops on the month’s last day. The formula for the EMONTH function is EMONTH (start_date, months).
yntax of EDATE and EOMONTH
EDATE
Start_date: A date that signifies the start date example, 1/22/2021. Do not enter the start date in the text; a problem will happen. The start_date is required.
Months: Month represents the number of months before and after the Start_date. The months’ positive value returns a future date, and the negative value returns a past date for the months.
EOMONTH
Start_date: A date that signifies the start date example, 1/22/2021. Do not enter the start date in the text; a problem will happen. The start_date is required.
Months: Month represents the number of months before and after the Start_date. The months’ positive value returns a future date, and the negative value returns a past date for the months.