How to Get the Last Day Of Any Month In Excel

How to Get the Last Day of Any Month in Excel
In a previous tutorial I’ve explained how you can use the Eomonth function in excel and return the last date of any months. In this tutorial, I’ll show you how you can get the last day of any month using the same function.
Let’s say today is 13th August, 2021 and the last date of this month is 31st August, 2021. Now I want to find out which day is it in excel. In our case it will be Tuesday. This is what I will find out.

Now that we have our last date let’s get the last day of the month.

Step 1: Go to the Home Tab
Step 2: Open Format cell or you can press CTRL + 1
Step 3: Now click on custom
Step 4: Now write dddd
Click ok and done. You’ve got the last day of the month.

Now in the custom formatting where you’ve written dddd follow the below instructions for more precise formatting:
D = Date in single digit like 1
DD = Date in double digit like 01
DDD = Day Name in 3 digits Like TUE
DDDD = Day name in Full like TUESDAY

This is how you filter last day of any month in excel.

#LastDay #Month #Excel

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media: