+ Reply to Thread
Results 1 to 2 of 2

formula to output upcoming quarter end date (for a broken fiscal year)

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question formula to output upcoming quarter end date (for a broken fiscal year)

    I am looking to create a function that outputs the upcoming quarter end date based on a specified start date, for which the quarter end is based on a broken fiscal year ending december 15.

    As an example, say that you sign up as a customer with an internet provider on 2014-01-01. The internet provider charges all their clients on a quarterly basis and have a broken fiscal year ending on december 15. Hence, as you signed up on 2014-01-01 you will be charged on 2014-03-15, which is the date of the company's first quarter end.

    So what I would like to do is to set up a function that outputs the first date I will be charged based on the date that I sign up. If I sign up between december 2013-12-16 and 2014-03-15, the formula should output 2014-03-15. If I sign up between 2014-03-16 and 2014-06-15, the formula should output 2014-06-15 etc. etc.

    I would really appreciate any helpful comments.

    Many thanks!

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: formula to output upcoming quarter end date (for a broken fiscal year)

    Something like:
    =DATE(YEAR(A1+15),3*MONTH(1+INT(A1+15)/3),15)
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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. 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
  2. Fiscal Year + Quarter
    By brotherwo in forum Excel General
    Replies: 11
    Last Post: 01-08-2011, 02:10 PM
  3. Fiscal Quarter/Year into a date format
    By bluerog in forum Excel General
    Replies: 2
    Last Post: 12-14-2009, 02:36 PM
  4. Date Format - Quarter and Fiscal Year
    By bluerog in forum Excel General
    Replies: 1
    Last Post: 11-04-2009, 12:04 PM
  5. 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