one more question, if Monday's a holiday how would the coding be to add that into Friday's totals? I currently have a table called tbl_Holidays where field one is called "Holiday" and the other field is called "Date". I was trying to see if the coding arnelgp first posted for excluding holidays to include it in the If statement but I get an error due to the DCount line.