Translate Dates into Text for Day of Week

Smokeyham

Board Regular
Joined
Feb 1, 2006
Messages
110
Hello,

Using Excel 2007 I have a table which has dates and number of visitors. I wanted to translate the date into a day of the week.

Easy enough I thought; just choose special formatting. That works, but I need the day to actually be text. If I copy the "day of the week" and paste special (value) then I end up with a number as shown in Column D. Any thoughts on how I can get the text for the day instead?

What I will want to do eventually is write a formula which increases the number in Column B by a factor, depending on the day of the week.

Thanks for any ideas.


Excel Workbook
ABCD
1DateNumber of PeopleDay of WeekPaste Value
26/8/2014258Sunday41798
36/9/2014169Monday41799
46/10/2014177Tuesday41800
56/11/2014187Wednesday41801
66/12/2014195Thursday41802
76/13/2014273Friday41803
86/14/2014332Saturday41804
96/15/2014402Sunday41805
106/16/2014178Monday41806
116/17/2014208Tuesday41807
126/18/2014175Wednesday41808
136/19/2014264Thursday41809
146/20/2014268Friday41810
156/21/2014369Saturday41811
166/22/2014303Sunday41812
176/23/2014152Monday41813
186/24/2014166Tuesday41814
196/25/2014196Wednesday41815
206/26/2014189Thursday41816
216/27/2014207Friday41817
226/28/2014338Saturday41818
TRAFx Daily totals (2014-05-23
 

irakrakow

New Member
Joined
Apr 24, 2014
Messages
22
Use the TEXT function, with the "dddd" format. The formula in Cell E2 would be:

=TEXT(A2,"dddd")

Then copy the formula down Column E.
 

vogel997

Active Member
Joined
Jan 22, 2010
Messages
412
try this
=TEXT(A2,"dddd")
<colgroup><col width="236" style="width: 177pt; mso-width-source: userset; mso-width-alt: 8630;"> <tbody> </tbody>
 

Smokeyham

Board Regular
Joined
Feb 1, 2006
Messages
110
Thanks so much for the responses! That worked exactly the way I need to. Much appreciated!
 

Forum statistics

Threads
1,085,693
Messages
5,385,214
Members
401,936
Latest member
stephenpoff

Some videos you may like

This Week's Hot Topics

Top