# How to Get Last Day of Month – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 8, 2023

This tutorial will demonstrate how to get the last day of a month in Excel and Google Sheets.

## Get Last Day of Month

With the EOMONTH Function it is really straightforward to calculate the last day of a month.

``=EOMONTH(B3,0)``

The syntax of the EOMONTH function is EOMONTH(start_date, months). The ‘months’ argument specifies the number of months before or after the start_date.

So if you need the last day of next month, you can simply use:

``=EOMONTH(B3,1)``

You can also easily display the last day of last month like this:

``=EOMONTH(B3,-1)``

## Last Day of Month – Text

Instead of displaying the last day of the month as a standard date, you can display it as text, using the TEXT Function.

``="The last day of the month is " & TEXT(EOMONTH(B3,0),"mm/dd/yyyy")``

Notice here, we’ve specified the date format of “mm/dd/yyyy”. There are many other date formats available to you.

## List Last Days of Month

You can even create a list of the last days of months with a given starting date.

``=EOMONTH(B3,C3)``

## How to Get Last Day of Month in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.