I am trying to finish a somewhat complex spreadsheet that shows what happens
when we sell various properties in the future. I have a €œper diem€� interest
carry formula that works fine. I am showing what happens financially based
on the individual property estimated exact sales date (including a specific
day of a month & year). I have a 10 year results area that fully computes
and gives me the individual properties resulting projected net cash flow.

My problem: How do I write a formula that looks at the specific date (in a
column) a property sells (say €œ4/17/2012€�) and then posts the prorated cash
flow results into another column on the same line labeled (and showing only)
€œ2009, 2010, 2011, 2012, etc€�?

Thanks for any help you can give me.

hardlook