View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jordan Jordan is offline
external usenet poster
 
Posts: 144
Default Counting Days of the Week

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