If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|