Thanks xld,

I tried your formula and the value in CW6 evaluates to 0. I know that there is at least 1 instance of an inspection in January 2010 because of the date in AA28.

Could it be an error in my defined name range? I did a lot of fiddling around with that and am not confident I've defined it properly as don't fully understand about offsetting