SUMIF between two dates but not including weekends

[mrdzyyyrawr]

I have a spreadsheet that details each employee's sales for each day. I currently use the following formula to calculate an employee's sales figues between 2 dates located in cells G5 & G6. Cell D6 contains a drop down list containing each employee's name.

=IF(D6="Employee1",SUMIFS(Summary!C1:C445,Summary!A1:A445,">="&G5,Summary!A1:A445,"<="&G6)/D7,IF(D6="Employee2",SUMIFS(Summary!K1:K445,Summary!A1:A445,">="&G5,Summary!A1:A445,"<="&G6)/D7,IF(D6="Employee3",SUMIFS(Summary!S1:S445,Summary!A1:A445,">="&G5,Summary!A1:A445,"<="&G6)/D7,"")))

I'd like the exact same result but to exclude weekend data.

Any help would be greatly appreciated.

 

[kvsrinivasamurthy]

Pl post a sample data with required result.