Consulting

Results 1 to 12 of 12

Thread: Excel day of week conversion

  1. #1
    VBAX Regular
    Joined
    Jun 2004
    Location
    New Jersey
    Posts
    52
    Location

    Excel day of week conversion

    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)
    Russ

  2. #2
    VBAX Mentor CBrine's Avatar
    Joined
    Jun 2004
    Location
    Toronto, Canada
    Posts
    387
    Location
    =CHOOSE(WEEKDAY(A16),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
    I knew there was a better way.

    =TEXT(WEEKDAY(A16),"DDDD")
    The most difficult errors to resolve are the one's you know you didn't make.


  3. #3
    VBAX Regular
    Joined
    Jun 2004
    Location
    New Jersey
    Posts
    52
    Location
    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
    Russ

  4. #4
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    It's even easier than that, you just need ..

    =TEXT(A16,"dddd")
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

  5. #5
    VBAX Regular babsc01's Avatar
    Joined
    Jun 2004
    Location
    Southaven, MS
    Posts
    53
    Location
    Shoot...someone already posted the TEXT example. Thought I was gonna help for once!

  6. #6
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    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.

  7. #7
    VBAX Tutor SJ McAbney's Avatar
    Joined
    May 2004
    Location
    Glasgow
    Posts
    243
    Location
    And in VBA:

    Format(ActiveCell, "dddd")

  8. #8
    Site Admin
    The Princess
    VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Or, even one better that doesn't require an additional column:

    Format the cell as mm/dd/yyyy dddd

    Right?
    ~Anne Troy

  9. #9
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Quote Originally Posted by Dreamboat
    Or, even one better that doesn't require an additional column:

    Format the cell as mm/dd/yyyy dddd

    Right?

    Almost ...

    Quote Originally Posted by firefytr
    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.

  10. #10
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    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...?
    ~Anne Troy

  11. #11
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Oh, right. That is a very good point! And you're exactly right, beautiful!!

  12. #12
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Zack?
    Did you just call me "beautiful"?

    LOL!!
    ~Anne Troy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •