0

Sheet Replicator by Month with Column Replicator Starting Week on 1st day of Mo.

In the attached report replicating Sheets by Month, and Columns by Week.  Need help in getting Column replicator by week to start on the week on 1st day of each month.

Would like Feb and the following months to look like January Tab.  

February Sheet starts Week 1 on Feb 5 because the first week of February is Week 6 of the Year, which is Feb 5, 2018, but I want each Month Tab to start over on the 1st day of Month and then replicate a column for each week of that month.  

I'm using Period Type "Week" and it doesn't work the way I need it.  I understand why it doesn't work, but haven't been able to come up with anything that does work.  Below are screen shots of Feb and Jan tabs.

Appreciate any help.






 

 

2 comments

Please sign in to leave a comment.