View Single Post
  #1  
Old March 4th, 2004, 05:32 PM
Dana
external usenet poster
 
Posts: n/a
Default Calculating a rolling calendar year

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?