Hi Tim,

I'm still not clear what you want to automate.

Is this a timesheet you use or the employees use?

I generate these numbers and use them as a reference when the employees fill
out the timesheets to ensure that they are "starting" and "ending" on the
correct dates for the pay periods.

Why not just copy your formulas down another 52 rows?

These 'references' are actually good for two years. I wanted to automate it
so that at the end of the two years the employees wouldn't have to remember
to update that one date field that starts the entire generation of pay period
dates.


Dan