Excel 2007 : Create formula referencing two different columns

I'm having a hard time creting a formua for the issue below. It seems easy, but I just can't seem to get it.

I have two columns. "B" is a column in a date format that shows days of the week such as 06-sep-11, 07sep-11, etc. This date column can have the same date listed numerous times but it only lists dates for one week at a time (Sunday through Saturday) of a single week. Column "AD" lists employee names (Bob, Sarah, etc.). Each employee can have their name listed multiple times in this column.

I would like a formula that counts the number of times an employee is listed, but only for the first half of the week (Sun-Wed). Another cell woudl do the same, but for the second half of the week (Thursday to Saturday).

I thought of using WEEKDAY to find the cells/rows where the day of the week is <5 (sun-wed) and then matching that to the cells in column AD where the name matches an employee, but I can't figure out how to write this..

Does anyone have any ideas? i just can't figure it out.... Maybe thinking too hardo n this. Thank you in advance for any help.