PrabasTech

# Excel Functions EDATE vs. EOMONTH

Excel is a fantastic application that gives us numerous functions and formulas to solve many of our calculation needs. It saves a ton of times. In this tutorial we learn the basic usages of EDATE and EOMONTH Excel functions with a practical scenarios.

EDATE

In this scenario, we find 720 months from the employees date of birth which is his date of resigning

• Syntax of EDATE function is =EDATE(start_date, months)
• start_date is a Required argument, it represents the start date. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2020,8,15) for the 15th day of August, 2020.
• months is a Required argument, the number of months before or after start_date. A positive value for months gives a future date; a negative value gives a past date.
• If start_date is not a valid date, it returns the #VALUE! error value.
• The month input value should be a number

EOMONTH

We use EOMONTH date in this tutorial, using EOMONTH function we get the last date of the month of his resigning date

• Syntax of EOMONTH function is  =EOMONTH(start_date, months)
• Both start_date and months are mandatory arguments
• start_date – a date that represents the starting date. Dates should be entered by using the DATE function (or) using a direct year value
• months – the number of months before or after start_date. A positive value for months gives a future date; a negative value gives a past date.
• Month input value should be a number
• If start_date is not a valid date, EOMONTH function returns the #NUM! error value.