Days of the week

  • Thread starter Thread starter Ian
  • Start date Start date
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.
 
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
 
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...
 
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
 
Back
Top