rolling 3 month tracking

[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

 

[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

 

[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

 

[grizzly6969]

--
grizz

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