Associating a date with a specific FY
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Associating a date with a specific FY

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    For exampe: I have a column of dates in column L, and I have dollar figures in columns C through J. The column headings in C - J are Fiscal Year 2002, Fiscal Year 2003, etc.... If the date range for the following FY's are as follows:

    FY02: 10/01/01 - 09/30/02
    FY03: 10/01/02 - 09/30/03
    FY04: 10/01/03 - 09/30/04
    FY05: 10/01/04 - 09/30/05
    FY06: 10/01/05 - 09/30/06
    FY07: 10/01/06 - 09/30/07

    then the $ amount should appear in the appropriate FY and in the out years.

    So if: a date should fall on 10/30/04, than the funds should appear in FY05, FY06, FY07. All other funds should not be displayed.

    This one was real tough... I would greatly appreciate any help!

    Thanks!

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    124
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Are the dollar figures in columns C-J the same within in each row?

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Posts
    124
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    OK, move your dollar amounts to one column, say column M.

    Now, if your column headings in C-J are exactly as stated in your post and your dates are in column L and the money is in column M then in C2 paste:

    =IF($L2
    and copy through column J and down.

    Should work.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com