Excel - professionally designing employee attendance and absence sheets

The attendance and absence recording program for employees is supported by the feature of changing the date to suit all months, adding the employee’s name to the sheet automatically with the Visual Basic code, calculating the number of days of attendance and absence for each employee, coloring the day off in a different color automatically, and coloring the day of absence in red color automatically