Results 1 to 5 of 5

Thread: week num

  1. #1

    week num



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there i am trying to get excell to do the following

    WK 1

    for example i want to put the work WK short for week before the week num forumulae so it looks like WK 5 etc

  2. #2
    I want it to read WK 5 2017

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Perhaps:
    Code:
    ="WK "&WEEKNUM(NOW())&" "&YEAR(NOW())

  4. #4
    Hi thanks for this, the only issue now is that it is shows 31/12/17 as week 53 when infact it is week 52, what do i need to do to alter this.

  5. #5
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Excels weeknum function can result in a week 54 in some years! This is because:
    1. 1st January is always Week 1.
    2. But .... there is also a day number for each day of the week (1 to 7). By default, 1 is Sunday, to 7 (Saturday)
    So if 1st Jan is Saturday, that would be Week 1, but because day 1 starts a new week 2nd January becomes week 2, so Week 1 is only used on one day!.
    If you check out year 2000, 31122000 is Week 54.
    I suggest you look on the internet as the problem is well covered there, or you could use a date set of your own.

Posting Permissions

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