Creating Shifts/Weekends 24/7 Employees
Hello,
I am using Excel 2013's Employee Attendance Tracker template, however we are a 24/7 business and not everyone's days off are the same. I want to be able to select an employee and have the calendar change to their exact days off. Right now there is a drop down menu to the right that says "Select an Employee" which changes the calendar to that persons attendance history. Also, it says my calendar is an Array and will not let me alter it. How do I change that? I would like to be able to mark S (sick) or T (tardy) on the dates, and have it calculate at the bottom. I attached the file that I am working with. I am not good with formula's, I would really appreciate the assistance!
|