Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Week number (2003)

    I need to be able to work out away to give the week number based on the date - ie 2/10/06 = week 1; 11/10/06 =week 2 etc.

    Any thoughts?

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

    Re: Week number (2003)

    Do you mean the week number within the month? If the first week start on the first of the month, you can use the following formula to determine the week number of a date in A1:

    =1+INT((DAY(A1)-1)/7)

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: Week number (2003)

    Hans,

    Thanks for your quick reply and congratulation on your recent achievment.

    Your solution does just what I need - Thanks again

Posting Permissions

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