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).
Get Day-of-Week from Date
-
- UraniumLounger
- Posts: 9300
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Get Day-of-Week from Date
You do not have the required permissions to view the files attached to this post.
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: Get Day-of-Week from Date
BobH,
Try =TEXT(D2,"ddd")
It appears you're missing the comma.
Try =TEXT(D2,"ddd")
It appears you're missing the comma.
Regards,
John
John
-
- UraniumLounger
- Posts: 9300
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Re: Get Day-of-Week from Date
Thanks, John!
It's been a very long time since I used Excel much at all. Seems I've become very rusty with syntax.
It's been a very long time since I used Excel much at all. Seems I've become very rusty with syntax.
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |
-
- Administrator
- Posts: 12633
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Get Day-of-Week from Date
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;;
You could even surprress the display when column D is blank by specifying a format of dddd;;
StuartR
-
- UraniumLounger
- Posts: 9300
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Re: Get Day-of-Week from Date
Thanks, Stuart!
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |