Translate Dates into Text for Day of Week

[Smokeyham]

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
	A	B	C	D
1	Date	Number of People	Day of Week	Paste Value
2	6/8/2014	258	Sunday	41798
3	6/9/2014	169	Monday	41799
4	6/10/2014	177	Tuesday	41800
5	6/11/2014	187	Wednesday	41801
6	6/12/2014	195	Thursday	41802
7	6/13/2014	273	Friday	41803
8	6/14/2014	332	Saturday	41804
9	6/15/2014	402	Sunday	41805
10	6/16/2014	178	Monday	41806
11	6/17/2014	208	Tuesday	41807
12	6/18/2014	175	Wednesday	41808
13	6/19/2014	264	Thursday	41809
14	6/20/2014	268	Friday	41810
15	6/21/2014	369	Saturday	41811
16	6/22/2014	303	Sunday	41812
17	6/23/2014	152	Monday	41813
18	6/24/2014	166	Tuesday	41814
19	6/25/2014	196	Wednesday	41815
20	6/26/2014	189	Thursday	41816
21	6/27/2014	207	Friday	41817
22	6/28/2014	338	Saturday	41818
TRAFx Daily totals (2014-05-23

 

[irakrakow]

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]

[TABLE="width: 177"]
<colgroup><col width="236" style="width: 177pt; mso-width-source: userset; mso-width-alt: 8630;"> <tbody>[TR]
[TD="width: 236, bgcolor: transparent"]try this[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]=TEXT(A2,"dddd")[/TD]
[/TR]
</tbody>[/TABLE]

 

[Smokeyham]

Thanks so much for the responses! That worked exactly the way I need to. Much appreciated!