Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Day of Week to Match Date (Excel 97)

    This document is a daily booking sheet. On inserting the date in C1 the rest of the dates are update by adding one, however, I want to have the day of the week coincide with the date and update as well.

    Can anyone tell me how to do this?

    Thankyou

    Kerry
    Attached Files Attached Files

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

    Re: Day of Week to Match Date (Excel 97)

    In cell A1, enter the formula
    =C1
    Then, give this cell the custom number format "dddd" (without the quotes). This will format the cell as day of the week.
    ("d" = number 1...31, "dd" = number with leading zero 01...31, "ddd" is abbreviated day of the week Mon...Sun, "dddd" = day of the week Monday...Sunday).
    Cell A1 is not text any more, so the name of the day won't spill into the next column.
    You'll have to widen column A, or merge cells A1 and B1, or put the day of the week in another column altogether.

    Next, copy the cell with the day of the week, and paste it in the other cells containing the day of the week. The formula will adapt automatically.

  3. #3
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Day of Week to Match Date (Excel 97)

    Thankyou for your reply. It worked and I have learnt yet another trick I can use in future!

    Here is the finished result for anyone who is interested.

    Kind Regards

    Kerry
    Attached Files Attached Files

Posting Permissions

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