I am at a call center and need to calculate how many calls that we are taking on Sundays.
the dates are in the format 5/01/02 in B7:B200 there are of course 4 Sundays in May 5/5/02
5/12/02
5/19/02
5/26/02
Is there a way to count the number of Sundays in the B column, so that it counts all instances of sunday dates of:
5/5/02
5/12/02
5/19/02
5/26/02
Thank you all very much in advance.
Snedman
the dates are in the format 5/01/02 in B7:B200 there are of course 4 Sundays in May 5/5/02
5/12/02
5/19/02
5/26/02
Is there a way to count the number of Sundays in the B column, so that it counts all instances of sunday dates of:
5/5/02
5/12/02
5/19/02
5/26/02
Thank you all very much in advance.
Snedman