rolling 3 month tracking
 

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
--
grizz

rolling 3 month tracking
 

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"grizzly6969" wrote:

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
--
grizz

rolling 3 month tracking
 

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
--
grizz


"Shane Devenshire" wrote:

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"grizzly6969" wrote:

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
--
grizz

rolling 3 month tracking
 

--
grizz


"grizzly6969" wrote:

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
--
grizz


"Shane Devenshire" wrote:

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"grizzly6969" wrote:

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
--
grizz