Hi,
OK, still not absolutely sure, but what about using conditional formatting?
Have the results show up in ALL year columns, but set all the cells font
color white so they can't be seen.
In conditional formatting, put something like:
=YEAR(Cell with date)=Heading cell ref eg YEAR(D17)=D1
Set CF font color to black...

"hardlook" wrote:

Thanks Dave -
I have ten years spread over ten columns and I want to have a formula that
looks to see if my "date of proposed sale" cell (located on the same line)
tells it to cause another cells results to show-up here (by the year at the
top of this column) or not. Because all of the "sale" dates are different
(3/17/2010, etc.) I need to simply have that result show up in the approate
year (2009, 2010, 2011, etc.) column. Any thoughts?

"Dave" wrote:

Hi,
If your date 4/17/2012 is in A1:
=YEAR(A1-365) will return "2007"
=YEAR(A1-730) will return "2006"
Regards - Dave.