Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    day of the week ('97, SR2)

    What's the best way to generate a column that identifies the corresponding day of the week (Mo, Tu, We, Th, Fr, Sa, Su) for an adjacent column of dates?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: day of the week ('97, SR2)

    Say that the dates are in A1:A10.
    In B1, enter the formula =A1, then select Format | Cells..., activate the Number tab, select the Custom category, and enter ddd in the Type box, then click OK. Fill down B1 to B10.
    This will display the system abbreviation for the day of the week (in English, it is Mon, Tue, Wed etc.)

    If you really need Mo, Tu etc., put this formula in B1: =LEFT(TEXT(A1,"ddd"),2) and fill down to B10.

Posting Permissions

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