automatically fill cell with end of date monthly

hi,
I have a monthly reports generated by the button to create a new sheet,I want the new sheet A1 in cell filled with the date of the end of the month, Can the code that can automatically create entries, the sheet name is " jan10" ( end of date is jan 31), "feb10" (feb28).etc

thanks in advance
herukuncahyono