+ Reply to Thread
Results 1 to 3 of 3

Need to WEEKNUM function calculate weeks from Feb 1

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    34

    Need to WEEKNUM function calculate weeks from Feb 1

    Hi All,
    I need to use the WEEKNUM function in a way so that it returns week number 1 for the week 2/2/2014 to 2/8/2014. I tried to use the WEEKNUM function in Excel as it is and it returns different week number. The challenge is for my company fiscal year starts on 2/2/2014 and ends at 1/31/2015. Is there a way to pull out the week numbers for a given date if my fiscal year is different. Also, for us the new week starts on every Sunday.

    Any help is greatly appreciated in advance.

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

    Re: Need to WEEKNUM function calculate weeks from Feb 1

    Have a look at http://www.cpearson.com/excel/WeekNumbers.aspx

  3. #3
    Registered User
    Join Date
    11-04-2010
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Need to WEEKNUM function calculate weeks from Feb 1

    Awesome, that worked. Thanks you.

+ 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. [SOLVED] Function to calculate the nuber of weeks between dates?
    By Fish in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2006, 06:55 PM
  2. [SOLVED] Calculate 52 weeks
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 10:05 AM
  3. [SOLVED] Calculate 52 weeks
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 06:05 AM
  4. [SOLVED] Calculate 52 weeks
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] Calculate 52 weeks
    By Rainey in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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