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