Hello! I'm trying to use DAYS360 and an if statement...

Column A has 3 salespeople names: Jane, Joe, Bob
Column B is each customer name
Column C is a start date
Column D is an end date

I want to count the number of days it took Bob to complete his sales. Some of the end dates might be blank, so those associated start dates would need to be excluded.

I need to filter Bob in column A, though I only want to count his start dates (column C) > 1/1/2012 and his complete dates (column D) < 12/31/2012.

Please help! Thank you in advance!!!