EOMONTH allows us to return the date of the last day of a month, based on a specific date provided.

For example, we can use EOMONTH to find out what would be the date of the last day of the month, 3 months from the date October 2, 2019 (The answer would be January 31, 2020).

This function can be very useful for financial calculations, where the dates of the end of months and quarters are required for calculating financial ratios and measures. 


The syntax for EOMONTH is as follows:

EOMONTH(start_date, months)

start_date – Select the date from which we’d like to calculate the end of a certain month

months – how many months ahead/before should we go? Use the minus sign ( – ) to go back in time 🙂


OK, let’s see EOMONTH in action:

Easy, right? 🙂

Practice EOMONTH function

Now, let’s practice the EOMONTH function!