Attendance Tracking with Occurrence Points over 6 Month Rolling Period

That's the beauty of the Excel Table and the Summary sheet - you just add the employee to the table and the table expands and the Summary sheet will automatically include them. To not include vacation or sick days in the Total, use this formula in cell A9 on Summary page:

=LET(Names,UNIQUE(FILTER(Table1[Name],(Table1[Date]>=B5)*(Table1[Date]<=B6),"None")),
Vacation,COUNTIFS(Table1[Reason],B8,Table1[Name],Names,Table1[Date],">="&B5,Table1[Date],"<="&B6),
Sick,COUNTIFS(Table1[Reason],C8,Table1[Name],Names,Table1[Date],">="&B5,Table1[Date],"<="&B6),
Unexcused,COUNTIFS(Table1[Reason],D8,Table1[Name],Names,Table1[Date],">="&B5,Table1[Date],"<="&B6),
NCNS,COUNTIFS(Table1[Reason],E8,Table1[Name],Names,Table1[Date],">="&B5,Table1[Date],"<="&B6)*3,
Tardy,COUNTIFS(Table1[Reason],F8,Table1[Name],Names,Table1[Date],">="&B5,Table1[Date],"<="&B6)/2,
LateReturn,COUNTIFS(Table1[Reason],G8,Table1[Name],Names,Table1[Date],">="&B5,Table1[Date],"<="&B6)/2,
Total,Unexcused+NCNS+Tardy+LateReturn,
HSTACK(Names,Vacation,Sick,Unexcused,NCNS,Tardy,LateReturn,Total))

I'll attach the workbook with this change as well.

All names that have an occurrence within the date range will automatically show up on the Summary Page. If you have a situation where they are not, please attach the workbook so I can see what's happening.