Hello, I have a worksheet that has 7 tabs at the bottom; each one for the day of the week. I.E. Sunday, Monday, Tuesday, Wednesday. Each sheet is a maintenance log for my work that has a date at the top right. I need to have the date change to correspond with the day of the tab. Can someone help me make it so that after the day of the tab has passed it automatically inserts the new date in the worksheet for the following week.
For example,
On the Tuesday tab the day would show "Tuesday, January 18 2016" but tomorrow if I open the tab I want it to say "Tuesday, January 25 2016" since the previous day has already happened. I would like to be able to open the worksheet and click print and not have to worry about constantly changing the date of each tab every time to refresh the entire worksheet.
Thanks for the help!!!!!!
Bookmarks