+ Reply to Thread
Results 1 to 4 of 4

Fiscal week and fiscal week start date and end date

Hybrid View

  1. #1
    Registered User
    Join Date
    03-24-2007
    Posts
    88

    Fiscal week and fiscal week start date and end date

    I am trying to calculate my fiscal week number from a date, my fiscal year starts on 07/02/2011 and goes from Saturday to Friday. I am also trying to calculate the fiscal week start date and end date from the fiscal week number? Attached is the formula I was using for the week number.

    Thanks Nunzio

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Fiscal week and fiscal week start date and end date

    Hi Nunzio,

    You missed to attach the formula which you were using for the week number...

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    03-24-2007
    Posts
    88

    Re: Fiscal week and fiscal week start date and end date

    G2 is my date and this formula seems to be giving me the correct FW, how would I get the correct start and finish dates for the week from the results of this cell?

    INT((G2-WEEKDAY(G2+1)-DATE(YEAR(G2+7-WEEKDAY(G2+1)),1,1))/7)+28

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Fiscal week and fiscal week start date and end date

    Hi Nunzio,

    I am still not clear..
    Would suggest you to upload an excel file with the above formula with little explanation. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

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