Results 1 to 8 of 8

Search for fiscal quarter and year

Threaded View

  1. #3
    Registered User
    Join Date
    10-30-2008
    Location
    ma
    Posts
    35

    Re: Search for fiscal quarter and year

    The headings DO include the strings "1- ", "2 - " etc.

    The attached spreadsheet lists the actual headings.
    Note the formula in cell A2 is =SUM(J2:T2). what I'm trying to do is replace the hard-coded T2 with the cell reference of the quarter previous to the current quarter, shown in B1, taking the current year into consideration.

    In this example, the earliest 'Past Due' quarter is Q4 2007, so that is the data in cell J1. However, if that customer pays their bill, the next earliest Past Due quarter will become Q1 2009, and everything will move left accordingly, so the rightmost cell reference will change. (Col J will always be the first column in the range).

    Thanks.
    Attached Files Attached Files

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