Hi Chandoo,
Thanks so much for your blog, it's helped me a lot. I've been trying a Google search to solve my dilemma with no luck.
Currently my formulas look like this =IF(OR($T2<40787,$T2>41090),0,$W2)
meaning if the date in T2 is less than 9/1/2011 or greater than 6/30/2012, enter...