What is the EOMONTH function in Excel?
→ The MS Excel EOMONTH function calculates the last day of the month after adding a specified number of months to a date. The result is returned as a serial date.
→ It is a built-in function in Microsoft Excel, and we can put it in the DATE/Time Function Category.
→ It is a worksheet function. So, we can enter this function directly as a cell value.
→ This function returns a serial date value.
→ A serial date is how Excel stores date internally and it represents the number of days since January 1, 1900.
→ This function returns the date on the same day of the month either it may be in the past or it may be in the future.
→ We can use this function to calculate expiration dates, maturity dates, and other due dates.
→ With the help of positive value for months, we can get the future date, or similarly, by using the negative value for dates we can get the results in the past.
→ To move any date n months into the future or past, see the EOMONTH function.
What is the syntax of the EOMONTH function?
→ The syntax for the EOMONTH function in Microsoft Excel is:
=EOMONTH(start_date, months)
➨ The Syntax Parameter or Syntax Arguments of EOMONTH function are:
start_date - The starting date that we want to use in the calculation.
months - The number of months to add or reduce to the start_date. It can be a positive or a negative value
Important Note:
→ If a decimal value is provided for months, the EOMONTH function will only add the integer portion to start_date.
→ For this function, use a positive number for future dates and a negative number for dates in the past.
→ EOMONTH will return the #VALUE error if the start date is not a valid date.
→ EOMONTH returns a serial date that means the serial number of the date, which needs to formated as per our requirement..
Examples of EOMONTH Function:
→ For a detailed understanding, we will take some examples as mentioned below.
→ As we know the syntax of the EOMONTH Function =EOMONTH(start_date, months), So we will take the example accordingly.
Example – 01: Function with a positive value of the month
→ We will take this example by using syntax =EOMONTH(start_date, months), From the above picture the formula will be =EOMONTH(A2, B2).
→ This formula will return the last date of the month after adding the 8 months in the starting date value and the final result will be = 30-09-2015. (date is in dd-mm-yyyy format).
→ The initial result will be displayed into a serial date value so after formatting, it will be displayed in the dd-mm-yyyy format.
Example – 02: Function with a negative value of the month
→ Similarly, we will take another example by using syntax =EOMONTH(start_date, months), From the above picture the formula will be =EOMONTH(A3, B3).
→ In this example, we have taken the month value as a (-5).
→ So the formula will return the date value by adding the (-5) or we can say by reducing the 5 months in the starting date value and the final result will be the last date of the month = 30-09-2019. (date is in dd-mm-yyyy format).
Example – 03: Function with a decimal value of the month
→ Now we will take one more example for a better understanding of this function.
→ From the above picture, the formula will be =EOMONTH(A4, B4).
→ In this example, we have taken the value of months as a decimal value = 1.9
→ As per the syntax, the formula will only consider the month’s value as 1 from decimal 1.9
→ The formula will return the final result after formatting = 31-07-2020
👉 For a regular update:
➨ Join us (Telegram Channel)
➨ Join us (LinkedIn Page)
👉 Also Navigate Our Popular Category:
➨ Lookup & Reference Functions
Post a Comment