1. I want to create 365 sheets consecutively starting from 01JAN11 to 31DEC11
2. After creating 365 sheets, based on above sheet name format I want to insert date in a row in respective sheet as [$-409]dddd,mm,dd,yyyy (for ex. Saturday, January 01, 2011).
Can anyone guide?