Convert date field to text

[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!

 

[Don Guillett]

Perhaps a separate column with =weekday
=CHOOSE(WEEKDAY(B10),"S","M","T")

 

[Paul]

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!

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.

 

[Arvi Laanemets]

Hi

=TEXT(DateReference,"dddd")

 

[Alan]

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)



.