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

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

Use a helper col in your source data
If real dates are running in B2 down
In say, E2, copied down: =TEXT(B2,"ddd")
will extract the day. Then you could use the col header (with E1 labelled as
say: "Day") in your pivoting to get the desired results
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"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

Should there be the possibility of blank cells or formulas returning blanks:
"" in the source dates col B, use this instead: =IF(B2="","",TEXT(B2,"ddd"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

Hi,

1. Add a new column to your raw data area
D of W

Enter the following formula and copy it down

=TEXT(B2,"ddd")

2. Plot the pivot table using this new column A as the row field and calls,
column C as the Data field.

Plot this as your row field.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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