Results 1 to 4 of 4

Excel 2007, weeknum() returning incorrect number

Threaded View

  1. #1
    Registered User
    Join Date
    01-17-2007
    Posts
    13

    Excel 2007, weeknum() returning incorrect number

    Hi there.

    I need to use weeknum() for a number of situations in a project I'm working on.

    But when I use =WEEKNUM(DATE(2010;1;31)) it returns 6, instead of 4 as it should. Using it on today's date returns correct number.

    I'm clueless as to why...

    Any ideas?
    Last edited by jakobahman; 08-13-2009 at 03:48 AM.

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