Would like week number 1 to be first week in Jan with a Wednesday

Posted on 2014-08-29
Last Modified: 2014-08-29
Using weeknum function to number weeks but we use the first week in Jan that has a Wednesday as week 1.  Help on this please.
Question by:acdecal
    LVL 11

    Expert Comment

    by:Swapnil Nirmal
    Use it like this:

    LVL 44

    Accepted Solution

    I found this on the web. It assumes that A1 is January 1st of any year.


    Author Comment

    MartinLiss, that would work but now I need a function to produce A1,  Jan 1 of the year I select.  Say I have 2015 in a cell and I want A1 to be 1/1/2015
    LVL 11

    Assisted Solution

    by:Swapnil Nirmal
    Say value of B1 is 2015. The formula to be as below:
    LVL 44

    Expert Comment

    by:Martin Liss
    If "2015" is in A2 the put this formula in A1
    = "1/1/" & A2
    LVL 50

    Expert Comment

    by:barry houdini
    I see this question has been answered but I'm a little confused - isn't the requirement to get a week number from a date? Martin's solution returns a date, first Wednesday of the year.

    btw you can get that more easily with this formula if A1 is 1st Jan date


    regards, barry

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now