Find the Last Day of any Month | Excel VBA Macro Tutorial and Examples

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)
'

last day of any month

Related Entries

External Resources

Microsoft Excel 2003/2007 Video Tutorials
Step-by-step video guide to mastering Charts, PivotTable, Data Analysis and Macro programming in Microsoft Excel in 5 hours.
101 Secrets of Microsoft Excel
Discover 101 of Excels little-known secrets that have been hiding right under your nose.

Tagged with: excel formula, last day of month

2 Responses to 'Find the Last Day of any Month'

June 9, 2009 at 3:44 pm
hwsris

Thanks.
If the Day Number is over End of Month, It will go to nex month

DATE(2008,1,35) returns the serial number representing February 4, 2008.
June 9, 2009 at 3:48 pm
Poer

hi hwsris, that is why we use 0 in the Day number, to make sure that we will have the last day of the month.

Leave a Reply