Excel attendance exceptions: roster vs punches vs leave

Compute employees with no record on a day they should have worked; for example, who is missing from January 1 through January 2.

Compare roster, punch, and leave workbooks on matching keys to list who should have worked but has neither a punch nor leave. Templates included. Runs in the browser; no signup.

Upload roster, leave, and punch Excel workbooks, set the date range, then compute.

Download the template pack for a filled sample workbook and a header-only blank workbook. Map the required columns, compute in the browser, then export a result sheet. No signup.