In this article, we will learn about how to get the excel last day of the month.
At times, we need to know the expiry date of any product given its period of expiry and manufactured date. And you would be thinking why to do manually. Then YES. You are right. Excel function does your work here.
EOMONTH function is used to find the last day of the given month. It requires two things:
Syntax:
start_date : a valid date representing the start date for the function.
Months : a positive or negative number to get the date for after or before the start date.
Let’s get this with an example here.
Here we have start dates in the first columns and period of months in the second column.
Using the formula in the cell where we want the last day of the given month.
Formula:
Here arguments to the function is given as cell reference.
To get the 5 months after the 1st September 2014. What is the last day of that month? The month comes out to be february and last day of feb 2015 is 28th of Feb.
Copy the formula in other cells, select the cells taking the first cell where the formula is already applied, use Ctrl + D shortcut key.
As you can see from the above example, you can find the last day of any month using EOMONTH function.
Note:
Hope you understood how to find the last day of the month in Excel. Find more articles on Excel Functions here. Please share your query below in the comment box. We will assist you.
Related Articles
How to Get Month From Date in Excel
Convert Date and Time from GMT to CST
Get day name from Date in Excel
Popular Articles
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
