Need to track work attendance (absent/tardiness) via rolling 30 day point system.

Just insert a new column and copy the formula over, just changing the "NCNS" to "ED" or something and in the Total formula, just make sure the total still only lists the three columns you are wanting to count.

I think I did what you were looking for.

No clue what your other question is referring to though. Sorry.


Anyone have any help for my original question?

Originally Posted by jamesbolden2015

When you go to add a late or tardy it adds up correctly by the formula. But I want to be able to deduct for perfect attendance. So If I just go over to the total points column and subtract manually the formula is messed up. Meaning If I add another late or tardy it will not add at all.

I would like a column for Perfect Attendance that will subtract from the total. If you have 3 points but in 90 days you have perfect attendance then I will give you a 1/2 point reward = 2.5.

I am at work so I can't do much more, but you could do something like this. Just enter -1,-2 or whatever into the PA (perfect attendance) box and the formula will adjust.