Ask Experts Questions for FREE Help !
Ask
    mykonen's Avatar
    mykonen Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Oct 29, 2009, 12:14 AM
    One formula that convert any given date to week no.of the year.
    What are the formula in excel to convert any given date to the week of that date in that year.

    Example: 29 October 2009 is Week 44.

    TQ.

    Khalil.
    ebaines's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
    		  
    #2

    Oct 29, 2009, 06:03 AM

    Try this:

    =WEEKNUM(DATE(2009,10,29),1)

    If you get a #NAME? Error that means you need to install the Analysis Toolpack Add-In into Excel.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    Oct 30, 2009, 04:18 PM

    You can use a cell reference, too:

    =WEEKNUM(A1)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel: Convert numbers to date [ 4 Answers ]

I'm using excel 07 and I have a cell containing the number 11291997 which represents 11/29/1997. How can I convert this to a date format. The 11291197 is number formatted. Any suggestions would help, thanks!

How do I convert non-date string to a Date? [ 1 Answers ]

Hi - Okay, so here's my issue. I have a non-date string that I'd like to convert to a date format. This is what my non-date string looks like: 2009-01 and 2009-02, etc. I'd like to convert that to Jan-2009 or 01/09 under the date format. Can I do this?

Week formula in excel [ 1 Answers ]

When I entered some date, I want auto week formulation in another cell. Hope I made my question clear. Date Month Week 6-Nov-09 Nov 1st Week

Excel: date formula [ 5 Answers ]

Say you have a date (21/7/08) typed in a cell and want the cell directly below it to be automatically calculated 7 days from the date in the cell above (27/7/08). How do you do this? Then once you've done this, you want a column of dates to automatically appear as follows: 21/7/08 22/7/08...

View more questions Search