Since each date is just an increment over the previous day, you could
use the MOD function with the date and look at the remainder to
determine which day of the week each was. If you try the formula MOD
(A1,7)=0 you'll find that any Saturday will come out as 0 (because of
the calendar start).

On Jul 9, 7:41*pm, Jordan wrote:
I have a list of calls we recieve to a call center. *I'm trying to figure out
how many calls we get on each day of the week. *ie: Monday, Tuesday etc..

I can formatt the date to show MON or TUE but when I try and use the
informtion in a pivot table it still looks at the date Jan 12, formatted as
"MON" as a unique day. *I want all the Mondays to be added together.

Any help will be appreciated.

Jordan