| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rolling 13 Month Charts | Charts and Charting in Excel | |||
| 12 month Rolling Total | Excel Worksheet Functions | |||
| rolling 12 month average | Excel Worksheet Functions | |||
| How do I set up 12-month rolling month cells in excel? | Excel Discussion (Misc queries) | |||
| 3 month rolling chart | Charts and Charting in Excel | |||
Hybrid Mode
