Automated Worker Days Tracker

I need a clean, easy-to-maintain Excel workbook that lets me track attendance for my full-time staff and handles all vacation or day-off calculations automatically. When I drop a start date, an end date, or an absence code into a row, the sheet should:

• Mark the correct calendar days (including weekends) as worked or off
• Update each employee’s running total of worked days and remaining vacation automatically
• Flag any negative balances or overlapping requests so I can catch errors quickly

I’m fine with either dynamic formulas (e.g., SUMIFS, NETWORKDAYS, INDIRECT) or a lightweight VBA helper if that keeps the file fast and user-friendly. What matters most is that I can add a new employee or a new type of leave later without having to rewrite the logic.

Deliverable: a single Excel file ready for me to plug in names and see totals update immediately.