Get Day-of-Week from Date

User avatar
BobH
UraniumLounger
Posts: 8400
Joined: 13 Feb 2010, 01:27
Location: Temple - Deep in the Heart of Texas

Get Day-of-Week from Date

Post by BobH »

Can someone please help and old man with a tired brain?

I'm trying to get Excel to show the day-of-the week in a column B cell based on the value in the cell in column D of the same row. I first want to be certain that column D cell is not blank. I have managed to squirrel up the syntax until my brain is flummoxed. Please show me the error of my ways, other than the typo where you see a "K" in the formula).
day in excel.PNG
:cheers: :chocciebar: :thankyou:
You do not have the required permissions to view the files attached to this post.
Bob's yer Uncle!
(1/2)(1+√5)
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 7 >HPE 64-bit, MS Office 2016

jstevens
SilverLounger
Posts: 2456
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Get Day-of-Week from Date

Post by jstevens »

BobH,

Try =TEXT(D2,"ddd")

It appears you're missing the comma.
Regards,
John

User avatar
BobH
UraniumLounger
Posts: 8400
Joined: 13 Feb 2010, 01:27
Location: Temple - Deep in the Heart of Texas

Re: Get Day-of-Week from Date

Post by BobH »

Thanks, John!
It's been a very long time since I used Excel much at all. Seems I've become very rusty with syntax.
:cheers: :chocciebar: :thankyou:
Bob's yer Uncle!
(1/2)(1+√5)
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 7 >HPE 64-bit, MS Office 2016

User avatar
StuartR
Administrator
Posts: 11641
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Get Day-of-Week from Date

Post by StuartR »

If you just want to display the day of the week then you can make the values in column B equal to column D and format them as dddd
You could even surprress the display when column D is blank by specifying a format of dddd;;
StuartR


User avatar
BobH
UraniumLounger
Posts: 8400
Joined: 13 Feb 2010, 01:27
Location: Temple - Deep in the Heart of Texas

Re: Get Day-of-Week from Date

Post by BobH »

Thanks, Stuart!
Bob's yer Uncle!
(1/2)(1+√5)
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 7 >HPE 64-bit, MS Office 2016