Date to Day?

U

uberathlete

Board Regular
Joined
Jul 11, 2007
Messages
117
Hi everyone. I have a column of dates but they aren't exactly continuous or sequential. Is there any way to convert those dates into just day names? Any suggestions would be great. Thanks!
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
Aladin Akyurek

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
Hi everyone. I have a column of dates but they aren't exactly continuous or sequential. Is there any way to convert those dates into just day names? Any suggestions would be great. Thanks!
Click to expand...



You could format the relevant cells as ddd or, say, ddd dd/mm/yy
 
Upvote 0
U

uberathlete

Board Regular
Joined
Jul 11, 2007
Messages
117
Hi everyone. I have a column of dates but they aren't exactly continuous or sequential. Is there any way to convert those dates into just day names? Any suggestions would be great. Thanks!
Click to expand...



You could format the relevant cells as ddd or, say, ddd dd/mm/yy
Click to expand...

Awesome! Thank you!
 
Upvote 0
T

Tbar

New Member
Joined
Aug 21, 2007
Messages
2
Here's a formula

=CHOOSE(WEEKDAY(DC4,1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
 
Upvote 0
You must log in or register to reply here.

Similar threads

Q
  • Question
Average if or better solution
Replies
1
Views
173
arthurbr
arthurbr
E
  • Question
Calculate towards a date with two subtractions
Replies
0
Views
179
Excelquestion35
E
T
  • Question
Extract dates and data into another sheet
Replies
0
Views
108
tj2419
T
F
  • Question
VBA to Copy Sheet Rename to Next weekday and Change date in New Sheet
Replies
8
Views
453
FSUrf02
F
B
  • Question
Converting Text to Date - text to columns function
Replies
8
Views
526
Fluff
Fluff

Forum statistics

Threads
1,190,916
Messages
5,983,569
Members
439,850
Latest member
suhailrocks786

Share this page

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
Top