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

Answered in another workgroup. Please don't post the same question to more
than one!
 
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!
 
Back
Top