PDA

View Full Version : Excel day of week conversion



island17
09-01-2004, 10:45 AM
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:

CBrine
09-01-2004, 10:53 AM
=CHOOSE(WEEKDAY(A16),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturaday")

I knew there was a better way.

=TEXT(WEEKDAY(A16),"DDDD")

island17
09-01-2004, 11:13 AM
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

TonyJollans
09-01-2004, 11:55 AM
It's even easier than that, you just need ..

=TEXT(A16,"dddd")

babsc01
09-01-2004, 12:02 PM
Shoot...someone already posted the TEXT example. Thought I was gonna help for once!

Zack Barresse
09-01-2004, 02:26 PM
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.

SJ McAbney
09-02-2004, 02:26 AM
And in VBA:

Format(ActiveCell, "dddd")

Anne Troy
09-03-2004, 05:25 AM
Or, even one better that doesn't require an additional column:

Format the cell as mm/dd/yyyy dddd

Right?

Zack Barresse
09-03-2004, 09:03 AM
Or, even one better that doesn't require an additional column:

Format the cell as mm/dd/yyyy dddd

Right?


Almost ...


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.

So format cell as dddd.

Anne Troy
09-03-2004, 09:05 AM
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...?

Zack Barresse
09-03-2004, 09:09 AM
Oh, right. :) That is a very good point! And you're exactly right, beautiful!! :D

Anne Troy
09-05-2004, 10:22 PM
Zack?
Did you just call me "beautiful"?

LOL!!