View Single Post
  #2  
Old March 4th, 2004, 10:40 PM
external usenet poster
 
Posts: n/a
Default Calculating a rolling calendar year

Is there any way you can get by with recording data only
for those days on which the employee is not at work,
instead of recording data for every work day (I assume
that's what you're doing).
-----Original Message-----
I am trying to keep track of employee attendance (small
company - under 50 people) in Excel. I have created a
workbook that has a sheet for each employee. In Column

A,
I have listed the months and in B-AF I have the numbers

1-
31. I am using the corresponding cells (month/day) to

keep
track of attendance using codes (V-Vacation, etc.). I

have
set-up the sheets to calculate a cummulative total for

the
year. The problem is that our attendance works on a
rolling calendar year - for disciplinary purposes, we

look
from the current date back 90 days and count those
attendance occurances. Is there a way to calculate this?
.