Excel VBA Macro

Find the Last Day of any Month

Posted on the June 9th, 2009 under Excel Formula by Poer @ Excel VBA/Macro

Simple Microsoft Excel formula to find the last day of any given month.

'
=DATE(YEAR(A1),MONTH(A1)+1,0)
'