Paul,

I didn't even realize this was your thread until after I had posted my reply.

I would not do the time sheet the way you are trying. I would treat the time sheet as a UserForm Report, showing only the currrent pay period dates, which would automatically be adjusted for the current pay period (wkly, fortnightly, or monthly as desired by the driver,) or some past pay period if the driver chose to review his records.

Note that only if I wanted to allow printing of the Report, would I use a sheet based Report. Even with a sheet based Report, I would perform all calculations in the code, not with formulas. It is just too hard to adjust formulas if you change anything anywhere in the application.

I would include YTD values on it, and might show previous calculated payday totals for ease of comparing the record to the actual pay received.

There are two overriding considerations when designing and building an App: Ease of use for the End User and ease of modifying the App, because when it goes into production, the Users will find things you forgot or made a mistake on.