All articles with 'workday.intl()' Tag

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]

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 »