The first step is to add the dates of a particular month to the Excel sheet. Select a cell and type the date with the format DD-MM-YYYY. For example, to create the attendance sheet for October ...

Microsoft started testing checkboxes in Excel in October ... and it can take ages to manually add things up. Previously, I used boxes set as 1 or 0 to indicate attendance. While that worked ...