I have a sheet here. Our 2-week pay periods run from Sunday to Saturday. I want each employee to have his or her own time sheet like the one above which shows the current 2-week pay period always at the top with previous pay periods beneath.
I want F15 to always reflect the total of the current pay period so that I can share that cell's total on a master sheet for each employee as a single line item. I need a script to automatically add and populate the appropriate dates and weekdays for the next pay period as soon as the previous period ends.
For example, on the sheet above, when 5/13/2017 rolls over to 5/14/2017, 14 new rows will be added at the top of the page populated with the dates for the new 2-week period. That would mean that F15 would now be totaling the hours of the next two weeks as they are filled in each day by the employee.