Hi Del,

I think that keying the dates to any day other than the week-ending or week-starting date is a mistake. Since those dates will (presumably) be common to all employees, that's what you really should work with.

Apart from needing the week-ending or week-starting date, I wouldn't have thought any of the other dates would be needed; surely people only need to know which day of the week they're filling the form out for, rather than the date of that day as well, given that the whole form only spans one week.

Be that as it may, to make the report work as a form, you probably should use formfields, to constrain where/what the users can input. Have a play with the attached.

Attached Files

Attendance Report Template.docx (24.8 KB, 70 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]