Hello, I've been given the payroll task at my small company. Our time sheets are in excel, which I need to manually update each biweekly period. I am looking for help on writing a macro that will update the dates on my excel time sheet. Here is a sample, sorry it didn't copy over nicely. Thanks in advance!
<colgroup><col><col span="2"><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"></colgroup><tbody>
</tbody>
Pay Period | From: | 1/8/2017 | To: | 1/21/2017 | ||||||||||||||||||||||
SUN. | Date: | 1/8 | MON. | Date: | 1/9 | TUE. | Date: | 1/10 | WED. | Date: | 1/11 | THUR. | Date: | 1/12 | FRI. | Date: | 1/13 | SAT. | Date: | 1/14 | ||||||
SUN. | Date: | 1/15 | MON. | Date: | 1/16 | TUE. | Date: | 1/17 | WED. | Date: | 1/18 | THUR. | Date: | 1/19 | FRI. | Date: | 1/20 | SAT. | Date: | 1/21 | ||||||
<colgroup><col><col span="2"><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"></colgroup><tbody>
</tbody>