Covert date to text

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

Paul

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...

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

Mark Graesser

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
[email protected]


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