Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Indiana, USA
    Posts
    79

    Unanswered: Calculate day of the week

    Please Help

    I have an Excel Spreadsheet. Row 3 is filled across with dates - (consecutive Dates). Row 4 is for Days of the week.

    What I am trying to accomplish is ---

    Day of the week in row 4 to calculate based on date in Row 3 directly above it


    Example

    C3 = 3/16/04
    C4 = Tue

    Is this possible? We are tracking 100 days of data at a time and big pain to hand enter all those days of the week.

    Perplexed

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Give this a go:

    =TEXT(C3,"dddd")

    Hope that helps,

    Smitty

  3. #3
    Join Date
    Feb 2004
    Location
    Indiana, USA
    Posts
    79
    Thanks a bunch. This worked

    Perplexed

Posting Permissions

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