I am trying to average cells f2:f857
if the correspoding cells in b2:b857 = 1
E2:E857 is less than 03/01/2006
E2:E857 is greater than or equal to 02/01/2006
b:b contains numbers 1 through 7
e:e contains dates
f:f contains times
any idea what is wrong with my formula and how to fix it?