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

Thread: day name

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Larry
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what is the formula for the day name (not number)of a date? For example, May 8, 2002 is Wednesday. The only formula I found in Excel, DAY(), gives the day number of 4.

    The spreadsheet in the DOS program SMART had the formula: DAYNAME().

    Larry

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Custom format the cell as "ddd" for WED or "dddd" for Wednesday

  3. #3
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hello

    format the cell that contains the date
    using custom format

    dddd



    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    -----------------------------------------------------------------------------------------------------------------------------------------
    ANDREAS ( WINDOWS 7 PRO, MICROSOFT EXCEL 2010)

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    G'day,

    How about: =Text(A2,"dddd")

    where A2 holds your date.

    Adam

  5. #5
    New Member
    Join Date
    May 2002
    Location
    Larry
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 14:04, Asala42 wrote:
    G'day,

    How about: =Text(A2,"dddd")

    where A2 holds your date.

    Adam
    Thanks! Formula works great!

    Larry

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
  •