Hi all,
I monitor my workers attendance.
I use Excel 2007 and are planning to purchase 2010 soon.
Two questions:
1) Perfect attendance for 30 days: we take off 1 point
eg. 7/4/2011 to 8/3/2011
eg. 9/25/2011 to 10/24/2011
If there is no infraction and no points for any 30 day rolling period, I like to take off 1point automatically from the total points, which is 7 in this case.
2) 6 months roll-off:
6 months after the infraction, we remove whatever points are there.
eg. rows 5,6,7,8,9 and 10= have zero total
On 2/18/2012 I like to change 2 points to zero automatically.
Then this will be reflected in the total as 5 points.
(We are not removing the entire 7 points, just the 2 points that show up opposite to the original infraction)
How to do this. Help is greatly appreciated.
I am attaching a sample sheet.
The points is from Rolling total.
Every six months roll-off is, from the day of infraction.
Thank You.
Bookmarks