I create leave tracker
List of employee List of Employee.png
Leave tracker (listing of all staff's leave) Leave Tracker.png
Year-to-date summary Year-to-date summary.png
Currently, I use the pivot table to get the total days of each type of leave for employees and then manual input the total date of annual leave to the Year to date summary.
I want to set up a formula that can automatically summing up the Total Annual leave taken according to "leave tracker"
Should I still use the pivot table as a tool?
Bookmarks