+ Reply to Thread
Results 1 to 2 of 2

Fiscal Quarter/Year Moving Start Date

  1. #1
    Registered User
    Join Date
    07-30-2018
    Location
    Liverpool, England
    MS-Off Ver
    2016
    Posts
    1

    Post Fiscal Quarter/Year Moving Start Date

    Hi All,

    I am looking for a formula to calculate fiscal quarter/year based on a moving fiscal year start date.

    Fiscal Year Start Date = first Saturday of February (i.e February 3rd 2018 = Q3 2019)

    Fiscal Quarter Tenure = 4/4/5 (Month 1 = 4 Weeks / Month 2 = 4 Weeks / Month 3 = 5 Weeks) (i.e. Q3 2019 End of Quarter = May 4th 2018)

    Each fiscal quarter = 91 days (issue is leap years were Q1 would have 92)

    I know this can be done using a reference table, however I would like to have a formula that is transferable easier than having a separate excel reference as a reference table and having to add each time.

    Really appreciate any support on this.

    Thanks, Ryan

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,271

    Re: Fiscal Quarter/Year Moving Start Date

    try start date where A1 has the year in it

    Please Login or Register  to view this content.
    then you can just add days to get the the 4,4,5

    Does your fiscal quarter 2 really add a day in a leap year? that would mean your next quarter starts on a different day of the week kind of defeating the purpose...
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ 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 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
  2. formula to output upcoming quarter end date (for a broken fiscal year)
    By canaille in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2014, 05:01 PM
  3. how to convert date to fiscal year if fiscal year start at 16th or 17th of July
    By sushil shakya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2013, 03:32 AM
  4. Fiscal Year + Quarter
    By brotherwo in forum Excel General
    Replies: 11
    Last Post: 01-08-2011, 02:10 PM
  5. Fiscal Quarter/Year into a date format
    By bluerog in forum Excel General
    Replies: 2
    Last Post: 12-14-2009, 02:36 PM
  6. Date Format - Quarter and Fiscal Year
    By bluerog in forum Excel General
    Replies: 1
    Last Post: 11-04-2009, 12:04 PM
  7. [SOLVED] Date formula: return Quarter and Fiscal Year of a date
    By Rob in forum Excel General
    Replies: 7
    Last Post: 05-11-2005, 04:06 PM

Tags for this Thread

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