Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Novice here...

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

    Default

    Maybe I'm daft, but here's my no-such-thing-as-a-stupid question:

    If I enter a date (d/m/y) in a cell, can I automatically display (in a different cell) the DAY of that date?

    Told you I was a novice.

    Cheers (and thanks)!

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To get you started, have a look at the WEEKDAY function. Then you might look at the CHOOSE function.

  3. #3
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-04 14:55, mrs peel wrote:
    Maybe I'm daft, but here's my no-such-thing-as-a-stupid question:

    If I enter a date (d/m/y) in a cell, can I automatically display (in a different cell) the DAY of that date?

    Told you I was a novice.

    Cheers (and thanks)!
    Just use a formula and then custom format your cell. For example, if your date is in cell A1, use =A1. Custom format your cell with the formula to "dddd" (minus the quotation marks). To custom format, select Format|Cells and choose "Custom" in the category box in the Number tab. Put "dddd" in the Type box.

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    mrs peel
    assuming your date is in A1, in the other cell enter =A1 and custom format this cell as 'dddd'. to do this go to the format menu, select cells, number tab, select custom and type in dddd in the 'Type' box

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sorry barry - didn't see your post when i dove in

  6. #6
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-04 15:03, anno wrote:
    sorry barry - didn't see your post when i dove in
    Anno, are you sure you didn't copy my answer?



    _________________

    Barrie Davidson
    My Excel Web Page

    [ This Message was edited by: Barrie Davidson on 2002-04-04 15:04 ]

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

    Default

    Brilliant.

    Here's what worked (a combination of the fine advice here, and a wee bit of tweaking from the Help file):

    =TEXT(B11, "dddd")

    Where B11 contains the date.

    Much thanks.

    Cheers!

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    barrie
    i thought the same thing when i read your post, but the time stamp defeats me there
    i guess great minds think alike...
    have a good one

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
  •