Printable View
Hi Friends
Is there a way to convert 09/01/04 to "Wednesday" . I have a column in excel with dates and I would like to add a column next to it to tell me what day of the week corresponds with adjacent date. Is there a excel function to do this or is a macro needed. I write Word macros (VBA) but, I don't have a clue when it comes to excel.
Thanks
Island17 (Russ):ipray:
I knew there was a better way.Code:=CHOOSE(WEEKDAY(A16),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
Code:=TEXT(WEEKDAY(A16),"DDDD")
CBrine
Thanks, I saw the WeekDay function in excel help, but couldn't get it to work. Your tip worked fantastically.
As always
Thanks
Russ
It's even easier than that, you just need ..
Code:=TEXT(A16,"dddd")
Shoot...someone already posted the TEXT example. Thought I was gonna help for once!
A possibly even easier way, is to leave the cell as a date, use Custom Formatting "DDDD". This has a distinct advantage of you being able to use that date in dependent calculations later on if desired.
And in VBA:
Code:Format(ActiveCell, "dddd")
Or, even one better that doesn't require an additional column:
Format the cell as mm/dd/yyyy dddd
Right?
Quote:
Originally Posted by Dreamboat
Almost ...
So format cell as dddd.Quote:
Originally Posted by firefytr
Right, but that's only giving the day. He's got one column with the date. He wants one with the day. Now he has to have two columns.
If he just formats his original column the way I've shown, he doesn't need the extra column, and the date will still work in calculations...?
Oh, right. :) That is a very good point! And you're exactly right, beautiful!! :D
Zack?
Did you just call me "beautiful"?
LOL!!