I have searched a lot online but could not be able to find a suitable format for creating absence tracking sheet with absence rate formula on monthly basis.
I need help in creating an excel sheet with the below requirements:
Column A,B,C,D: Employee Name, Dept,Absence date(From - To), Total Days, Type of Leave (S, A, M, etc)
Additionally I need a calculation at the end that shows the absence rate during the specific month in the form of table or statistical graph.
I would appreciate if you could help me in this.