hello! i am not an expert with excel and im having trouble creating an excel spreadsheet that can help me track attendance for employees without it consisting of points. we have a system where tardy/incomplete shift rolls off after 30 days and Callouts rolls off after 90 days. i am trying to use the premade spreadsheet that is already provided from excel but i want to make some adjustments. if anyone is able to help me i would greatly appreciate it!
1.adding 2 formulas in 1 cell - i currently made 1 where if an employee calls out it automatically calculates the roll off date after 90 days in the leave tracker. but i cannot figure out how to ad another formula in the same cell that if tardy or incomplete shift it will roll off after 30 days.
2. is there a way to add the employee leave tracker tab to the calendar view tab on the bottom ? and for each employee to have its own tracker versus all sharing the same tracker ?
Bookmarks