How to auto-populate sequential dates on multiple tabs?

Hi,

I'm not an experienced programmer or excel user.
I've learned enough from searching to understand a bit about the module and code reading.
I'd like to see if someone can help with this...

I've created a weekly log to track my activities.
52 tabs for 52 weeks.

Is it possible to auto-fill the same spaces [B7-B13] across all the tabs with the correct sequential dates?

On each tab, Monday starts on B7 till Sunday on B13.
The format I'm using for dates is: [$-en-AU]dddd, d-mmm-yy format

This is an example of what my dates look like in a tab:

Monday, 2-Jan-17
Tuesday, 3-Jan-17
Wednesday, 4-Jan-17
Thursday, 5-Jan-17
Friday, 6-Jan-17
Saturday, 7-Jan-17
Sunday, 8-Jan-17

Hi,

Thanks for the replies.

@dflak
I'm currently populating the dates by putting in the first date for the week and then dragging it down till Sunday. I did this for this year, but I thought there surely has to be a better way.

@FDibbins
Thanks. Looking forward to learning from others here!
It's a sales activity report and I chose to have each week on a different tab b/c I write notes at the bottom and forward each week to my mentor. I'm including a copy of the excel document below.

Can I create a module of some kind and have it auto-populate the correct dates across all 52 weeks?

FDibbins,

Currently I'm doing something with the similar effect...dragging the first date till the last day, Sunday, and it's populating that way. I'm doing each tab this way.

Your idea would work in the similar way.

I'd like to see if there is a way to bypass all that and have a formula or something that would take care of the whole workbook, rather than doing each one individually.

If not, the manual way is always an option.

Is this what you wanted?

Please Login or Register  to view this content.

@jindon

Yes.
Thank you.

I'd like to do this for the 2017-2018/2018-2019...etc.
How can I adjust the date the code starts from?

Please Login or Register  to view this content.

The bold part is the start date, 2017(Year(Date)/1(Jan)/2 in this case
So Change that part as you want like 2018,1,2

If you are comfortable with formulas.
In B7 of any tab

Please Login or Register  to view this content.

In B8
=B7+1
then drag down till B13

Here is the code.
Keep a worksheet with all formats. Run the macro. It will generate all the 52 sheets.
Pl see attached file for demonstration.

Please Login or Register  to view this content.

Thank you @Fdibbins, @jindon, @dflak, and @kvsrinivasamurthy for all the help.

re: Your PM

Please Login or Register  to view this content.

This variation of the code worked.

edit: any concerns with this way?

Please Login or Register  to view this content.

Did you see my previous post?

If you can change the year directly for yourself and happy with that, just ignore my previous post.

Please Login or Register  to view this content.

Both work.
How can I change the day the first day starts on?

DateSerial(Year, Month, Day)

If 2018/1/4 then DateSerial(2018,1,4)

Thank you.