180 day rolling tracker formula

[AMLAS]

Hello

I am trying to create a tracker for attendance. The idea is to track the different codes- Vac, SSk, Usk (vacation, scheduled sick, unscheduled sick, etc) but I need them to fall off after 180 days. Each different attendance code has been converted into a number, so "late" is a number 5. on the right side are the totals. What I would like is to track on a 180 rolling period. so the SSK that occured on 01/03 will fall off 180 days later. any insight will be helpful as this is the first time I am attempting to do one with a rolling period.

Thank you in advance.

 

[Georgiboy]

Perhaps the use of OFFSET will help?

Book1
	A	B	C	D	E	F	G	H	I
1	1	2	1	1	2	1	1	1	6
Sheet6

Cell Formulas
Range	Formula
I1	I1	=COUNTIF(OFFSET(H1,,-7):H1,1)

 

[Fluff]

Maybe something like

=COUNTIFS($B4:$Z4,1,$B$2:$Z$2,"<="&TODAY(),$B$2:$Z$2,">="&TODAY()-180)

As we have no idea what cells you have shown, you will need to change the ranges to suit.

 

[AMLAS]

Maybe something like

=COUNTIFS($B4:$Z4,1,$B$2:$Z$2,"<="&TODAY(),$B$2:$Z$2,">="&TODAY()-180)

As we have no idea what cells you have shown, you will need to change the ranges to suit.

I really appreciate the insight on this @ Fluff and Georgiboy

 

[Fluff]

Did you try either of the suggestions after changing the ranges to suit?