Covert date 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!

 

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

Answered in another workgroup. Please don't post the same question to more
than one!

 

[Guest]

By DAY, do you mean day of the week. You could use the weekday function in another cell.

=WEEKDAY(A1) will return a number for the day

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

will return the day of the week in text.

Good Luck,
Mark Graesser
(e-mail address removed)


----- Alan wrote: -----

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!