Convert date field to text

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I have a mass of data with dates, which I need to group
by DAY. I have formatted the cell to custom "dddd" so
that it shows the day, however when i pivot report it
still reads the date. How can i convert the date field
to text to read the day? A straight forward format of
cell returns the date in number format.

HELP!
 
Alan said:
I have a mass of data with dates, which I need to group
by DAY. I have formatted the cell to custom "dddd" so
that it shows the day, however when i pivot report it
still reads the date. How can i convert the date field
to text to read the day? A straight forward format of
cell returns the date in number format.

HELP!
Click to expand...

Formatting cells doesn't change the data - only how the data is displayed.
You can add another column with formulas to extract the day from the dates:
=TEXT(A1,"dddd")
Then make your pivot table from this.
 
Worked a treat - thanks Don
-----Original Message-----
Perhaps a separate column with =weekday
=CHOOSE(WEEKDAY(B10),"S","M","T")
--
Don Guillett
SalesAid Software
(e-mail address removed)



.
Click to expand...
 
Back
Top