Arrow left
Back to product guides
Google Sheets Formulas

EOMONTH Function in Google Sheets: Explained

In this article, you will learn how to use the EOMONTH function in Google Sheets. This function is beneficial for checking a month's end date and showing months, such as table headers by month (e.g., monthly financial statement or monthly KPI tracker, etc.).

How to use the EOMONTH formula in Google Sheets

  1. Type “=EOMONTH” or go to “Insert”“Function” “Date”“EOMONTH”.
  2. Input a “start_date” and “months” by manual input or cell reference.
How to insert the EOMONTH formula from the menu bar in Google Sheets

The generic syntax of the function is as follows:

=EOMONTH(start_date, months)

Start_date: This should be a date. This date is a starting point from which the formula calculates the result.

Months: The number of months before (negative figure) or after (positive) the “start_date”. For example, if you enter “3/1/2022” for “start_date” and “2” for this argument, the formula returns the end date of May 2022, as three plus two is five.

As the function shows the end date of a month and adjusts the date shown monthly, it is helpful when you want to know the end date of a month or show months consecutively for a period (e.g., table headers for monthly data). Assume you are a finance manager and need to create a monthly financial and KPI dashboard for the first half of the fiscal year ending December 31, 2022. You want to make table headers by month. You can use this formula instead of typing all months for your data set.

How to use the EOMONTH formula in Google Sheets with an example

Start_date: For January 2022, we input it manually. Don’t forget to enclose the date with quotation marks. For each month from February to June, we refer to the next cell to the left. (e.g., cell B2(=1/31/2022) in the case of the formula for February (cell C2).)

Months: We input 0 for January because we input a date in January for “start_date” and want to know the end date of January. For each month in the rest of the period, we input “1” because we want to show the end date of a month, which is a month after the previous month.

In this example, we don’t care about the exact date but only the months. So, we are going to change the format of the cells. 

  1. Select a range “B2:G2”.
  2. Go to the “Format” tab → “Number” “Custom date and time”.
  3. In the pop-up window, delete the default input, if any, and click the pull-down menu next to the “Apply” button.
  4. Choose “Month”, type “-”, reopen the pull-down menu, and choose “Year”.
  5. Click the “Apply” button.
  6. Make the texts in the cells bold and white,  and color the cells blue.

Steps 3 to 5

What does the “Custom date and time” menu look like in Google Sheets?

After all steps

How to customize the format of cells containing dates

The format change above is just an example. You can customize the formatting of cells and dates according to your company’s coloring order or your preference.

How does HLOOKUP work in Google Sheets?

Read this article to understand how the HLOOKUP function works in Google Sheets.

How do I create a date formula in Google Sheets?

Check this article to learn how to use the DATE formula in Google Sheets.

How does Google Sheets calculate working days?

You can use the WORKDAYS or NETWORKDAYS functions depending on your purpose.

Other formulas related to date and time

If you don’t get the right answer to your question in this article or you have other questions related to date and/or time, you may find the answers in the following articles.

Formulas related to dates

How to Use EDATE Function in Google Sheets - understand a date before/after a specific number of days

DATEVALUE Function in Google Sheets: Explained - convert a date into a serial number

Formulas related to time

How to Insert Current Time in Google Sheets - NOW function

Analyze your live financial data in a snap

Are you learning this formula to build a financial model or financial KPI dashboard? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711