How do I create sequential dates across multiple sheets (Namely, Sept 01-30)

How do I create sequential dates across multiple sheets (Namely, Sept 01-30)?

I started a new job and was volun-told to make a document for my Chief of Security. I need to put dates (September) in a cell and “auto populate” (?) across the 30 worksheets (tabs) Also, I would like to do the same for the tabs themselves.
I have followed this module code

Please Login or Register  to view this content.

And then put in this code in the cell:
=AddSequentialDate("B1",B1)

I hit enter and #VALUE! Pops up.

How in the Bob Saget can I get it to work?

Thank you, kindly,

Scott

The given code seems to work.

Make sure you have placed the code into a standard code module (Insert > Module).

If you're using Excel 2013...

Assuming you already have the 30 daily sheets and you want the monthly dates in cell A1 of each sheet.

Select Sheet1
Press and hold the Shift key then select Sheet30
All sheets are now grouped

Enter this formula in cell A1:

=DATE(2014,9,SHEET())

The formula will be entered on all 30 sheets

Ungroup the sheets...
Right click any sheet tab>Ungroup sheets

I opened sheet 1 and entered a date in cell B1.

Then I selected sheet2 and entered your formula exactly as you showed and it put in the NEXT date as the result.

You're welcome. Thanks for the rep!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.