Sorry,
Here is a spreadsheet I'm working on. For each Unexcused absence I would
enter "U" for the date it happened on, or "T" for tardiness. I would like
to have 3rd occurrence within 6 months to either look different or to have
some kind of alert. Hope this is clear.

"January" is B4

Attendance Totals PTO
Tardy Unexcused Excused Balance
January 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 31 0 0 0 20

February 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 0 0 0 20

March 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 31 0 0 0 20

April 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 0 0 0 20

May 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
26 27 28 29 30 31 0 0 0 20

June 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
26 27 28 29 30 0 0 0 20

July 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
26 27 28 29 30 31 0 0 0 20

August 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 31 0 0 0 20

September 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 30 0 0 0 20

October 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 31 0 0 0 20

November 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 30 0 0 0 20

December 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 30 31 0 0 0 20




Pasha

"Earl Kiosterud" wrote in message
...
Pasha,

Attachments are disallowed in these groups. It's likely that no one will
open it. Describe the problem in enough detail, and we'll regail you with
solutions. Some may work!

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Pasha" wrote in message
...
I have modified MS's template (attached) to use for employee absence and
punctuality tracking. My company allows no more than 3 unexcused
absences
during any 6 months period. Same applies to tardiness. I would like to
have a macro that will track that automatically as I enter "T" or "U" in
the
spreadsheet. Any ideas would be greatly appreciated.

Pasha