Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: How do I convert the date to the corresponding day of the we

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am sure this has been asked before, but the search function is not working and I am just about blind from searching through the previous pages..... sorry.

    I would like to know how to convert the date to the correct day of the week. For example, in column A I have 4/1/02. I would like for column B to show "Monday". Is there a formula (or a button/filter/something) to do this?

    Thanks in advance for the assistance.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you use the formula
    =DAY(A1)
    and then custom format the cell as "dddd"
    Should do the trick.

    Rgds
    AJ

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Actually that doesn't work does it!

    Try copying your cells from column A to Column B and then reformatting them as "dddd" instead.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-19 07:22, PerfectTommy wrote:
    I am sure this has been asked before, but the search function is not working and I am just about blind from searching through the previous pages..... sorry.

    I would like to know how to convert the date to the correct day of the week. For example, in column A I have 4/1/02. I would like for column B to show "Monday". Is there a formula (or a button/filter/something) to do this?

    Thanks in advance for the assistance.
    Use =TEXT(A1,"dddd") in B1

    Or...

    just enter =A1 in B1 and format as dddd

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It works! Simple and effective. Thanks so much.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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