Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   One formula that convert any given date to week no.of the year. (https://www.askmehelpdesk.com/showthread.php?t=410777)

  • Oct 29, 2009, 12:14 AM
    mykonen
    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.
  • Oct 29, 2009, 06:03 AM
    ebaines

    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.
  • Oct 30, 2009, 04:18 PM
    JBeaucaire

    You can use a cell reference, too:

    =WEEKNUM(A1)

    • All times are GMT -7. The time now is 10:18 AM.