Macro that will rename all worksheets to dates

[taylorsm]

I have a macro that duplicates a worksheet however many times you want, but I want to be able to rename those sheets. I would like to name them the dates of the month. I do not know if there is a way to do that, and to do it with weekdays only.

I have the following macro that I've cobbled together from a couple different locations, maybe someone can iron it out for me. I was just going to have the macro pull names from a list, and have a list of the dates on a hidden page, but excel saves the dates in a format that won't transfer to worksheet name.

Please Login or Register  to view this content.

[AlphaFrog]

If the values in the array are serial dates, this will format the date-sheet-name to whatever format you like.

Please Login or Register  to view this content.