rolling 3 month tracking

G

grizzly6969

I must keep track of absenteeism for the year and if there is 3 absent days
in a rolling 3 month period for example if a person was off a day in Jan and
a day in Feb. and a day in March it will display 3 or as many days they have
had off but if he had a day off in Jan none off in Feb a day off in March and
a day off in April and a day off in May it will display rolling 3 months from
March, April and May
 
S

Shane Devenshire

Hi,

And what do you want it to display if they have 1 day off in Jan and Feb, 2
days off in Mar, and 1 day off in Apr and 3 days off in May? Jan-Mar = 4 but
Mar-May = 6
 
G

grizzly6969

only display if there is a minimum of 3 days off in a rolling 3 month period.
it can display the number of days
2 in Jan + 1 in March = 3 = display or
0 in Jan -- 1 in Feb + 1 in March + 1 in April = 3 = display
 
G

grizzly6969

--
grizz


grizzly6969 said:
only display if there is a minimum of 3 days off in a rolling 3 month period.
it can display the number of days
2 in Jan + 1 in March = 3 = display or
0 in Jan -- 1 in Feb + 1 in March + 1 in April = 3 = display or
1 in Jan -- 0 in Feb -- 0 in March -- 1 in April + 0 in May + 2 in June + 3
= display
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top