"=COUNT(AND(Sheet1!L2:L96<=DATE(2009,3,31)),(Sheet1!O2:O96>=DATE(2009,4,1)))

I am trying to look at Column L and if the date is earlier than 2009,4,1 and the date in that row in Column O is later than 2009,4,1 THEN count that entry. I have tried all sorts of permutations and the above is a correct formula but it does not return the correct value.