Menu
All articles with 'workday.intl()' Tag
{ 16 Comments }
Find last day of any month with this simple trick [formulas]
Published on Nov 21, 2013 in Excel Howtos
![Find last day of any month with this simple trick [formulas]](https://chandoo.org/wp/wp-content/uploads/2013/11/last-date-of-month-formula.png)
Here is a handy trick to calculate last day of any month.
Assuming y and m contain the year & month for which you want to find the last day’s date, write
=DATE(y, m+1,0)
That is right, you can use ZERO (0) as the day.
When you do this, Excel tells us the last day of previous month.
Continue »
