Associating a date with a specific FY

[christal]

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!

[cpod]

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

[christal]

Yes

[cpod]

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.