EOMONTH

Formulas / EOMONTH
Return the serial number of the last day of the month in a given year.
EOMONTH(start_date, months)
  • start_date - required, a date
  • months - required, the number of months in the future or past

Examples

  • =EOMONTH(B5,0)

    The function can be used to find the end of a month by adding a certain number of months to a given date. In the example given, the result is the end of that month, May 31, 2017.

  • =EOMONTH(B5,4)

    The function can also be used to find the end of a month by adding a certain number of months to a given date. In the example given, this results in the end of that month, September 30, 2017.

Summary

The EOMONTH function is a useful tool for calculating dates that fall on the last day of a month or the first day of the next month. It takes a year as an argument and returns the corresponding serial number for the last day of the month.

  • The EOMONTH function takes two arguments: start_date and months. It returns the last day of the month for the given start_date and number of months.
  • The start_date argument must be a valid date in the current workbook, and the months argument specifies how far into the future or past to move.


Frequently Asked Questions

What is the EOMONTH function?
The EOMONTH function returns the serial number of the last day of the month.
How does EOMONTH work?
The serial number returned is the day of the month specified by the argument. EOMONTH works with dates entered with the DATE function.
What are the arguments for the EOMONTH function?
The EOMONTH function has two required arguments:
  • start_date - The start date from which to calculate the end of the month.
  • months - The number of months to add to the start_date.
What is the syntax for the EOMONTH function?
The syntax for the EOMONTH function is as follows: EOMONTH(start_date,months).
What is the return value of the EOMONTH function?
The EOMONTH function returns the serial number of the last day of the month.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV