Buy Simple Sheets Employee Scheduling Template
https://www.simplesheets.co/a/2147525...
All purchases help to support this channel thanks!

Download the featured file here https://www.bluepecantraining.com/wp...

In this video I demonstrate how to create an attendance sheet in Microsoft Excel. The attendance sheet has the following features:

1) You can select a month and year and it will show a calendar with nonworking days formatted in grey. The nonworking days include bankholidays or any other holidays you want to specify
2) The current day is shown on the calendar in orange
3) You can specify 'P' for present, 'A' for absent or 'H' for planned absence. These values can only entered on working days
4) A count of present, absent and planned absence days for the month
5) A percentage breakdown of present and absent days for the month

Table of Contents:

00:00 Intro
01:32 Create the attendance report dropdowns for month and year
05:22 Create the date headings (Excel 365)
12:51 Create the date headings (Old Excel)
17:20 Conditional formatting to show nonworking days in grey, today's date in orange and P, A, and H in different colours
26:13 Data Validation to prevent entry on nonworking days
30:22 Attendance record summary calculations