Increment Date based on Worksheet number

**IamDavidH** · 02-24-2011, 12:53 PM

I need to create "Daily Worksheets". What I would like to do is have a front worksheet that requests "Start Date". Then I would like the next 90 sheets to increment the date slot by one day to reflect that start date + the worksheet number (i.e. start date = 2/20/2011 and the worksheet labeled "6" would have an autodate of 2/25/2011). Both the start date as well as each of the daily dates appear on cell B3. I saw an OFFSET command but could not figure out how to pull the worksheet label to add to it.

**Greg M** · 02-24-2011, 03:46 PM

Hi there,

Have a look at the attached workbook which contains the following code:

Please Login or Register  to view this content.

I think this will do what you want. The only thing is that worksheet names may not contain the "/" character, so the names of the newly-added sheets have the format "mm-dd-yyyy" rather than "mm/dd/yyyy".

Hope this helps - please let me know how you get on.

Regards,

Greg M

P.S. Do you need a "Confirm Action?" prompt to prevent you from accidentally deleting existing worksheets? If so, just let me know and I can add one.