I have 10 employees, each with their own excel sheet with their name. Going through each to change the dates at the top where it says "Pay Period x/x/xxxx through x/x/xxxx" is a pain. Our pay period is 14 days. It would sure save me a lot of time if I could just change a single number on that line, and it would change the rest. Is there a way I can change the first date next to the "Pay Period" line, and it will auto change every thing else correctly? Thanks

It basically looks like this but with a second week under the first:


$Name$ Pay period: 1/3/2015 through 1/16/15

Saturday Sunday Monday Tuesday Wednesday Thursday Friday
1/3/15 1/4/15 1/5/15 1/6/15 1/7/15 1/8/15 1/9/15
In
Out
In
Out

Total