HLOOKUP Setting Range in formula

[rhynoe]

Goal:

Track Number of times employee is Late in a rolling 12 week period

Attempted Method

Start // Date Manually entered
=C3 // Entered 1/1/2012

End
=C3()+84 = 3/25/2012

I have dates horizontally (D1:CO1)

RANGE1 Start RANGE2 End

In theory i would like to =Countif (hlookup(Start : END), "Late")
Obviously this does not work but I hope you get the idea. The next part would be each range would be a row down and counting Lates in that range.

Any help would be appreciated

 

[konew1]

Try this.=COUNTIF(OFFSET(D1,1,MATCH(C3,D1:CO1)-1,1,84),"late")
I think you have the dates in D1:CO1 and the word "late" in D2:CO2. Modify the ranges to suit your data layout

 

[rhynoe]

You are amazing and I bow down to your skills. Thank you so much, worked like a charm