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!
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!