Days of the week

I

Ian

I want to attach the days of the week to data to be
analyzed in a pivot table. I have a colomn with date in
it but is there any way to get the mon, tues, etc... in
another column?

Thanks.
 
B

Bob Flanagan

Add another column to your data that uses the following formula:

=TEXT(E4,"ddd")

If the value in the referenced cell is a date, the above returns the day in
text form.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
G

Guest

Thanks.
-----Original Message-----
Add another column to your data that uses the following formula:

=TEXT(E4,"ddd")

If the value in the referenced cell is a date, the above returns the day in
text form.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel




.
Click to expand...
 
D

Dave Peterson

One more option is to include the date and day in the same cell.

If you rightclick on the field
select Field Settings
Number..

Give it a nice Custom format:
mm/dd/yyyy dddd

I like this one:
mm/dd/yyyy* dddd
 
Top