Sorry Bob,

I was hoping to show how many people had left after a certain date, so I was trying to count how many people had a start date (Deleted_FTE Column E) that is less than the date in column B and that also had a leaving date (Deleted_FTE Column F) that was greater than column B.

So, with the spreadsheet supplied it should count zero until it reaches row 7, 27/04/09, and then count 1.

I am obviously doing something really wrong though???