Dates and days of the week

  • Thread starter Thread starter MJ
  • Start date Start date
M

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.
 
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
 
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
 
Uh - that's: your cell is CUSTOM formatted...
Right-click the appropriate field header & select Format Cells (XL 2007)
Click to expand...
- then select Custom. Check out OLH for date formats, but the formats
quoted below should give you a clue
 
Back
Top