
Company Magazine
Docs + Word7 pages
FeaturedFree
Team leads and HR assistants rely on this workbook to record each employee's department, role, start date, working days and contracted hours. The Staff tab holds one row per person. The Leave tab logs each absence with its type, first and last day, status and working days, which the sheet counts with NETWORKDAYS so weekends drop out. The Dashboard shows headcount, contracted hours and approved leave by department and by leave type.
Update the Staff tab whenever someone joins, changes hours or leaves, and keep the Leave tab current as requests move from Requested to Approved or Declined. Only Approved leave reaches the approved days total, so check each status before you plan cover. The working days formula leaves out weekends but counts public holidays, so take those out by hand if your company observes them.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Staff tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
The working days formula excludes weekends only. To leave out public holidays as well, add a list of holiday dates as the third argument of NETWORKDAYS, or subtract those days by hand. Check your company's leave policy for how holidays count toward leave.
This sheet records leave taken, not the allowance. Add an allowance column on the Staff tab, then subtract each person's approved annual days from it. Your leave policy sets the allowance itself.
Not automatically. Sort the Leave tab by First day and scan for dates that overlap. Look each name up on the Staff tab to see its department before you decide who covers the shifts.

Docs + Word7 pages
FeaturedFree
Docs + Word21 pages
FeaturedFree
Slides + PowerPoint16 slides
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free