How do I post specific dates into a colums labled only by Year?
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
|