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.
Bookmarks