formula on getting weekday with lookup to other tab.

Hi Guys,

Could anyone here can help me on how to lookup a total number of records by weekday.

Attached is spreadsheet as sample.

I want activity by owner summary to get records from email data. i.e. on activity by owner summary have different data owner and i want to lookup the data from email data tab in data owner.

thanks alot..

kindly assists me on this. i need this sample report very badly.

thanks again.