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 ...