Not clear.
What gets entered in the B, C and D columns?
What gets entered under a date column?
Under a date do we have a code for short-****/late/absent?
Can someone be late AND have short-shift on one day?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Clark" wrote in message
...
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