Translate Dates into Text for Day of Week

Smokeyham

Board Regular
Joined
Feb 1, 2006
Messages
120
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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.
 
Upvote 0
try this
=TEXT(A2,"dddd")
<colgroup><col width="236" style="width: 177pt; mso-width-source: userset; mso-width-alt: 8630;"> <tbody> </tbody>
 
Upvote 0
Thanks so much for the responses! That worked exactly the way I need to. Much appreciated!
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top