Hey there,,

I am trying to make a weekly excel tab on excel. I have 53 tabs, the first tab being a running total and then 52 tabs all for each week of the year..

I want all the tabs to be able to automatically update the dates from the first tab..

So in the second tab (WEEK1) I have cell B1 with the start date.. c2 is the day after and so on for 7 days.

I want to all the other tabs to be able to auto update if I change the very first date.. Any help???