Dates and days of the week

[MJ]

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.

 

[Pete_UK]

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

 

[Bob Alhat]

Your cell is formatted as "dddd, mmmm d, yyyy" or"dddd, mmmm dd, yyyy".
The field in the pivot table needs to be formatted the similarly.
Right-click the appropriate field header & select Format Cells (XL 2007)

HTH
Bob

 

[Bob Alhat]

Uh - that's: your cell is CUSTOM formatted...

Right-click the appropriate field header & select Format Cells (XL 2007)

- then select Custom. Check out OLH for date formats, but the formats
quoted below should give you a clue