Sarah,

Try this:-

=IF(TODAY()-C9030,"","What figure would you like ?")

"Sarah (OGI)" wrote:

I have a date in cell C90.
I need a formula in K90 that keeps the cell blank when the month of today()
does not exceed 1 full month after the month in C90. Eg, if the date in C90
is 3rd Jan 07 and the month of today() is up to and including Feb, I want the
cell to be blank. As soon as the month of today() = March, then I want a
figure to be shown, i.e. I want to be able to perform my getpivotdata
function.

Any ideas?