once every year, ideas please ?

[dido22]

Hi

I am developing a simple financial spreadsheet which will span several
years, and in which the rows are 1 month apart.

The columns are investments whose current value can be calculated only on
its 1st. 2nd 3rd etc anniversary. I want all intermediate cells to remain
blank.

So an investement bought in April 2007 will display its value in Apr 2008,
Apr 2009 etc etc, but leaving blank cells in between.

I can do this OK, but it is messy ! The financial calculation is easy. I
know how to calculate the difference (in days or months or years) between
the 'start' date and the current date. But I end up with a complex IF
function which returns a null string unless the difference in dates equals
1,2, etc years, or 12, 24, etc months or 365, 730 etc days.

Does anyone know a more elegant way of displaying a formula only on the
anniversaries ?

Thanks

KK

 

[Bob Phillips]

Not sure of actual cells, but something like

=IF(MONTH(investment_date)=MONTH(value_date),calculation,"")