+ Reply to Thread
Results 1 to 3 of 3

Fiscal Year 2010 has 91 weeks?

  1. #1
    Registered User
    Join Date
    07-29-2008
    Location
    FL
    MS-Off Ver
    XL 2007 & 2008
    Posts
    27

    Fiscal Year 2010 has 91 weeks?

    My fiscal year begins October 1. During the 2010 fiscal year, when the formula encounters week ending 12/26/2009, the following formula returns 91 for the fiscal week while it returns the correct week number for all other weeks.

    The week ending date is in the F column in short format: 12/26/09

    SUM(53-(INT((F2-WEEKDAY(F2+1)-DATE(YEAR(F2+7-WEEKDAY(F2+1))-(MONTH(F2)<10),10,1))/7)+2))

    This only happens when the formula encounters this one week? Can anyone point me in the direction of a solution?

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Fiscal Year 2010 has 91 weeks?

    So if F2 contains a Saturday date your formula should give the number of weeks until the end of the financial year? Try

    =INT((WEEKDAY(F2)+DATE(YEAR(F2+99-WEEKDAY(F2)),9,30)-F2)/7)-1
    Audere est facere

  3. #3
    Registered User
    Join Date
    07-29-2008
    Location
    FL
    MS-Off Ver
    XL 2007 & 2008
    Posts
    27

    Re: Fiscal Year 2010 has 91 weeks?

    That seems to have done the trick, Thanks!

    Any idea what was causing the error in my original formula?

+ 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