+ Reply to Thread
Results 1 to 2 of 2

Custom weeknum formula - Beginning 4th Jan :-(

  1. #1
    Forum Contributor
    Join Date
    02-14-2008
    Location
    Manchester, England
    MS-Off Ver
    2007
    Posts
    110

    Custom weeknum formula - Beginning 4th Jan :-(

    Happy new year all

    Hoping someone can help. I use the =WEEKNUM(A1,2) formula in loads of my spreadsheets. For some unknown reason my company have started week 1 this year on 4th Jan which means a lot of the automated reports I run are having to have dates manually updated.

    Is there a work around for this or a custom formula I could use?

    Thanks
    Dan

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Custom weeknum formula - Beginning 4th Jan :-(

    Perhaps have a look at http://www.cpearson.com/excel/WeekNumbers.aspx under " week number first day of week"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 11-25-2015, 06:44 PM
  2. [SOLVED] Weeknum - formula
    By chief_abound in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2015, 09:49 PM
  3. Weeknum - Formula
    By Meelkoppie in forum Excel General
    Replies: 1
    Last Post: 11-26-2014, 06:05 PM
  4. Need Custom WeekNum and Year format
    By SJMaye in forum Excel General
    Replies: 5
    Last Post: 03-11-2010, 10:33 AM
  5. Custom function for weeknum to Month i got some issues with this need alittle help
    By robertjtucker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-28-2006, 10:44 AM
  6. Replies: 0
    Last Post: 02-24-2005, 02:19 PM
  7. Custom Format for WEEKNUM(Today())
    By RonB in forum Excel General
    Replies: 2
    Last Post: 01-12-2005, 03:06 PM

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