PrabasTech

Excel Function EDATE vs. EOMONTH

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.

Download Excel

for Practice

If you watch and understand the entire tutorial along with the practice, it is a great time saver in such scenarios. 

I hope you understood and practiced the entire concept. Thanks for your time for reading this article.

Want to receive weekly insights  tips & tricks

then register here

Chat
1
Join
PrabasTech Welcome you.
Would you like to join a course?