Results 1 to 8 of 8

Calculate the Week in the quarter using Fiscal week and a Date

Threaded View

dalfane177 Calculate the Week in the... 10-12-2016, 10:11 AM
Glenn Kennedy Re: Calculate the Week in the... 10-12-2016, 11:10 AM
dalfane177 Re: Calculate the Week in the... 10-12-2016, 02:05 PM
JohnTopley Re: Calculate the Week in the... 10-12-2016, 02:44 PM
Glenn Kennedy Re: Calculate the Week in the... 10-12-2016, 02:53 PM
Glenn Kennedy Re: Calculate the Week in the... 10-12-2016, 03:18 PM
dalfane177 Re: Calculate the Week in the... 10-13-2016, 05:14 PM
Glenn Kennedy Re: Calculate the Week in the... 10-14-2016, 04:09 PM
  1. #1
    Registered User
    Join Date
    10-12-2016
    Location
    USA, New Jersey
    MS-Off Ver
    2013
    Posts
    3

    Question Calculate the Week in the quarter using Fiscal week and a Date

    I know the following.
    Column I,J,K,M,N
    Fiscal Yr
    Fiscal Wk
    Fiscal Qtr Num
    Fiscal Qtr
    Completed Date

    What I am trying to determine is what week in the fiscal QTR are we at based on the Completed Date?

    Our Fiscal Year Starts in February and our weeks start on Saturday and end on Friday.
    This year we started our Fiscal Year on Jan 30 2016.
    We use 13 weeks as a default within each Fiscal QTR.

    I tried this formula in another worksheet just using the completed date and it does not match up.
    =1+(WEEKNUM(EDATE(B2,-1)))-(WEEKNUM(DATE(YEAR(EDATE(B2,-1)),LOOKUP(MONTH(EDATE(B2,-1)),{1,4,7,10}),1)))

    Results
    The 30th of Jan to the 5 of Feb should be week 1 of Q1.
    (Fiscal Week in QTR) (Completed)
    14--------------------1/31/2016
    1---------------------2/01/2016
    2---------------------2/05/2016
    2---------------------2/07/2016
    3---------------------2/10/2016

    any help would be appreciated.

    Dal.
    Last edited by dalfane177; 10-12-2016 at 10:17 AM.

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. Calculate Start & End Date & Month for Each Week In Fiscal Year
    By sarndt01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-22-2014, 02:14 PM
  3. Calculate week number for Fiscal Year Dates
    By Ginu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2013, 03:10 PM
  4. Calculate # of sales per week, month & quarter
    By AlcatrazT2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 06:25 PM
  5. [SOLVED] Calculate Next Fiscal Quarter End Date
    By kmarron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-05-2012, 05:46 PM
  6. Fiscal week and fiscal week start date and end date
    By Nunzio in forum Excel General
    Replies: 3
    Last Post: 05-07-2012, 01:25 PM
  7. How do i calculate fiscal week of the year
    By evlai@hotmail.com in forum Excel General
    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