top of page


The EOMONTH function enables us to obtain the date corresponding to the last day of a given month, using a provided specific date. By utilizing EOMONTH, we can determine the date of the final day of a month, for instance, three months after a given date like October 2, 2019 (which would result in January 31, 2020).

This function can prove highly advantageous in financial calculations that involve determining the end-of-month and end-of-quarter dates. These dates are often necessary for computing various financial ratios and measures in financial analysis.

The syntax for EOMONTH is: =EOMONTH(start_date, months)

bottom of page