Modifying Formula in Excel Premade Tracker Sheet.

Good Morning,

I recently downloaded the Employee Tracker Sheet from the Microsoft website, and I am curious if there is a way to modify some things on there.

Link to said sheet.
https://templates.office.com/en-us/E...ker-TM02780235

Question 1: I work for a large medical facility and we track our employees absences using the provided sheet above, however, if the days are consecutively taken off we only consider it as 1 absence. For example, if you call out on the 9th, 10th, and 11th because you were sick, we'd only consider that as 1, but the tracker sheet lists it as 3 absences. Is there any way to make consecutively missed days recognized as only one missed day?

Question 2: For people who are constantly calling out, we allow up to 5 missed days before a performance write-up is given, and then we start to monitor the employee a bit more closely. Is there a way to create a marker or something that will show individuals with 5 or more absences, so we can closely monitor those specific employees?

Think that's it for now, thank you in advance!

-Shane

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post