Never thought of that DGagnon.
Lol but here is the attachment. I modified the original to reduce the size of the file and highlighted the formula cells that I am having trouble with. I think it is pretty self explanatory.

Thanks in advance.

Tom

Attendance_Sample.xlsx