Count Number Of Days Since Employee Last Day Of Recorded Absence / Tardy

I am trying to get the correct formula to count the number of days it has been for each employee since the last occurrence of an absence/tardy. For each employee, starting with the beginning of the year, we mark and employee as Absent as an "A" or Tardy as "T". See below the examples.

Employee Name
Date:
1/1
1/2
1/3
1/4
1/5
1/6
1/7
1/8
1/9
1/10

[code]....

We are keeping track so that employees have the ability to make up numbers because after so many occurrences they can become terminated. If an employee has about 60 days in a row without an infraction, that employee can deduct a day from their total on the year.

Also to include a vlookup so that I could have their name as well with the number of days on a separate tab!