+ Reply to Thread
Results 1 to 2 of 2

Week Number and Year

  1. #1
    Registered User
    Join Date
    01-10-2008
    Posts
    18

    Week Number and Year

    Lets try this again...

    I am using this current formula to calculate the week number, though what I need to include is the year as well. I am using a getpivot on another sheet to compare to =now.

    =INT((C138-SUM(MOD(DATE(YEAR(C138-MOD(C138-2,7)+3),1,2),
    {1E+99,7})*{1,-1})+5)/7)

    What I am looking for:
    01/2008
    Week/Year

    Any help in the right direction would be great!

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Try this formula

    =TEXT(INT((C138-WEEKDAY(C138,2)-DATE(YEAR(C138+4-WEEKDAY(C138,2)),1,4))/7)+2,"00\/")&YEAR(C138+4-WEEKDAY(C138,2))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1