Get the last day of the month in Excel with easy steps
A free Office suite fully compatible with Microsoft Office
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
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
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
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
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.
Was this helpful?
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. How to compare two excel sheets and highlight differences
- 3. Check if value is in list in Excel (3 easy methods)
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula