Results 1 to 12 of 12

Fiscal Year + Quarter

Threaded View

  1. #1
    Registered User
    Join Date
    12-10-2008
    Location
    Kansas
    MS-Off Ver
    2007
    Posts
    91

    Fiscal Year + Quarter

    This question has been asked many times but my solution is not working...
    here is my formula

    ="FY"&YEAR(AH2)+MONTH(AH2>=7)&"--Q"&INT(1+MOD(MONTH(AH2)-7,12)/3)

    Im trying to have a formula that calculates FYXX QX with the fiscal year ending June30th

    This formula is saying 5/1/10 is fiscal year 11 instead of 10


    THX
    Last edited by brotherwo; 01-07-2011 at 05:57 PM.

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