What Excel really thinks is in that cell is the number 39813 - how it
is displayed is all down to the formatting applied to that cell.

In a helper column you can use this formula:

=TEXT(B3,"dddd")

to show the full day, and then copy this down. Then use this column
for your PT.

Hope this helps.

Pete

On Feb 4, 4:54*pm, MJ wrote:
In cell B3 it reads Wednesday, December 31, 2008 but if I put my cursor in
the cell it shows only 12/31/2008 as the contents. *I want a pivot table that
shows day of the week as well as date. *With this formatting it only shows
the date not the day of the week. *I have tried formatting as date, text, and
general and cannot get the info showing to really be what Excel thinks is in
the cell. *