+ Reply to Thread
Results 1 to 3 of 3

Calculate week number for Fiscal Year Dates

  1. #1
    Registered User
    Join Date
    07-16-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Calculate week number for Fiscal Year Dates

    My fiscal year starts on July 29th and I have a total of 52 weeks in a year. Sunday is considered the first day of the week. How do I calculate the week number of a specific date? For instance, if the date is 7/15/2013, the week number should be 51.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Calculate week number for Fiscal Year Dates

    Try this..

    =INT((B1-DATE(YEAR(B1+156)-1,7,29)-WEEKDAY(B1))/7)+2

    Adaptation of DDL's formula in this thread
    http://www.excelforum.com/excel-gene...html?p=3311103
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    11-01-2012
    Location
    Madisonville, KY
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Calculate week number for Fiscal Year Dates

    try setting up a lookup table in a seperate tab so when you enter a date the week number will pull from the lookup table
    Attached Files Attached Files

+ 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. Calculate week number for Fiscal Year Dates
    By katie_10042 in forum Excel General
    Replies: 16
    Last Post: 02-14-2017, 05:58 AM
  2. Convert date to week number for fiscal year starting July 25
    By ARayburn in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-15-2013, 10:07 AM
  3. Replies: 6
    Last Post: 05-08-2013, 01:46 PM
  4. autocalculate current week of fiscal year?
    By zb61 in forum Excel General
    Replies: 6
    Last Post: 06-14-2012, 02:29 AM
  5. Replies: 4
    Last Post: 09-22-2005, 10: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