Employee Work Sheet.xlsxHi newbie question here,
In my spreadsheet I manually type what week it is being used for. This week I typed:
"For the week of 6/4/2012 - 6/8/2012"
Is there a way to make it so that when I load up the spreadsheet next week (6/11), it will automatically change it to show:
"For the week of 6/11/2012 - 6/15/2012".
What would be even one step cooler, would be if it could clear out all of the cells that had information in them for each week too.
I.E. it keeps the base template and removes all of the inputted values from the previous week.
Thanks for any help if possible, Adam
Bookmarks