I'm trying to automatically fill some cells in a spreadsheet that's
linked to a MS Project file. There are 5 cells - the first one is the
cell linked to Project so it will show the current figure. In the
other cells I want to show the figure depending on the date, 1st Qtr,
2nd Qtr etc. I thought I had the 1st qtr sussed with:-

=IF(TODAY()<DATE(2009,4,1),J5,"")

but of course as soon as I get to 1st April, the cell will go blank,
which I don't want as the data is tracked on various charts. I'm also
unsure how to do the other qtr's.

Sorry if this is blindingly obvious, I'm quite new to this so any
advice will be greatly appreciated!