Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Week # dates (MS Office 97 SR1)

    Hi

    I will try to keep this simple I have a workseet with cell entries of Week 1 Week 2 etc, I need to know the date the week commenced, ie Week 1 = 01/01/2002,
    the cells are not adjacent so I cannot use the series fill.
    If you can help I would be most grateful.
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    If you are a fool at forty, you will always be a fool

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Week # dates (MS Office 97 SR1)

    Try:
    =(WeekNumber-1)*7+DATE(2002,1,1)

    where weeknumber is the week number (1 through whatever)

    Steve

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Week # dates (MS Office 97 SR1)

    Assuming you're using the ISO weeknumber and not the US one:

    =DATE($Q$1,1,1)+(C2-IF(WEEKDAY(DATE($Q$1,1,1),2)<5,1,0))*7-WEEKDAY(DATE($Q$1,1,1),2)+1

    Q1 contains 2002
    C2 contains the weeknumber
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Week # dates (MS Office 97 SR1)

    Hi thanks very much I had two replies and they both work fine, I am very grateful for your help
    If you are a fool at forty, you will always be a fool

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Week # dates (MS Office 97 SR1)

    Hi thanks very much I had two replies and they both work fine, I am very grateful for your help
    If you are a fool at forty, you will always be a fool

Posting Permissions

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