Spreadsheet containing accured holidays holidays taken ect

Here’s a crude start.

You’ll have to duplicate the weeks until you get a full year. I only did through the first week in February.

The Employee info page contains the summaries. The table in columns E:F show the kinds of time that can be logged and whether they contribute to accrual.

The dates in column H are the holidays (I made these up).

Any vacation time carried over can be entered into cell L1.

Track time on the Time Card Sheet. The helper cells are displayed. You can hide these. The current week’s date is highlighted in green and any holidays are highlighted in tan.

The holiday time sheet is used to track when people work on a holiday. The weeks also must be expanded and this sheet can be hidden.

This should give you an idea of how to organize a sheet.