Imagine spreadsheet with names of all employees in coloum A. Coloums B, C,
and D are labeled Absent, Late, and Short Shift. All the rest of the coloums
are by date. I need 2 things. First my companies attendance policy says that
if you have more than 4 points in 90 days then bad things happen. Short sifts
and late arrivals are .5 of a point and absent is 1 point. I need to have a
formula that can calculate 90 days in the past and give me each employees
point total from the current date. Second, i need to enter lates and short
shifts by both code and time. Example is SS6 meaning that someone left 6
minutes early. How can i do this and not screw up the above formula?

Any ideas?
--
Clark