Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Returning text form of Weekday function (2000)

    I am familiar with the Weekday function in that it returns a number that corresponds to a day of the week. What I am looking for is a function (or combination of more than one, if necessary) that instead of returning a number that corresponds ro a day of the week (for example a "1" would represent a Monday) the function would return the actual text of the particular weekday.
    Thanks,
    Jeff

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Returning text form of Weekday function (2000)

    If the date is in A1, then <pre> =IF(A1="","",TEXT(A1,"dddd"))</pre>

    should work

    Andrew C

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Returning text form of Weekday function (2000)

    Andrew-works great! Thanks a bunch. One of these days I'm gonna learn all these little tricks!
    Thanks again, and Happy New Year!
    Jeff

Posting Permissions

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