Get the last day of the month in Excel with easy steps

July 22, 2022
860 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

You've looked at your income and expenses for the month, you've checked all your bank accounts, and you've even checked again. But no matter how many times you check Excel, it still says Month ends today. Your calendar says tomorrow but your spreadsheet does not. It's frustrating to not know what day of the month it is, and this usually leads to lots of unnecessary phone calls from clients in need of answers. Don't worry! I'll show you how I can get the last day of any month in Excel.

How do you get the last day of the month in Excel? This is a question that I'm sure many experienced Excel users have faced before. And if you're not sure how to do it, then there's a good chance that you've been Googling last day of the month on Google. Well, this article will teach you how to get the last day of the month in Excel and how to format it

Tips that are provided in this article are compatible with versions 2010/2013/2016.

How to get the last day of the Month in Excel: EOMONTH function

The first method to get the last day of the month in Excel is by using the EOMONTH function, EOMONTH function helps in finding the end of the month. The syntax of this function is

EOMONTH(date, [start_date])

Where date is a text string or a cell reference. If it contains a text string, it must be in the format yyyymmdd. If it contains a cell reference, it must be in A1-style (that is, with A1 being the first column). start_date is an optional argument that specifies the starting date for finding dates.

If start_date is omitted, then EOMONTH looks for dates from January 1 to December 31. If start_date is specified as a cell reference, then EOMONTH looks only from that cell.

Lets look an example here

1.We want to find the last of the month of date in A2 cell ,we will write it as

EOMONTH(A2,0)

2.The result as you can see is the date on that day of the month.

3.Now you know it’s that easy to get the last day of month in excel

How to get the last day of the previous Month in Excel: EOMONTH function

1.Sometimes you are working on excel and you need to check what day it was on the last date of the last month so that to move further with calculations ,for that we need to modify our formula as

EOMONTH(A2,-1)

2.Now from the example above you can see that this formula has returned us the last day of the previous month

How to get the last day of the next month

1.Looking at the previous section might have wondered you how you can get the last day of the  next month , it’s also very easy task, just use this formula

EOMONTH(A2,1)

2.And that’s it ,that’s how you find the last day of the next month using excel

Did you learn about how to get the last day of the month in Excel? You can follow WPS academy to learn more features of Word documents, Excel Spreadsheets, and PowerPoint slides.

You can also download WPS office to edit the word documents, Excel Spreadsheets, and PowerPoint free of cost. Download Now! And get an enjoyable working space.