Hi Sarah

Try
=IF(MONTH(TODAY())-MONTH(C90)<2,"",your_value)

--
Regards

Roger Govier


"Sarah (OGI)" wrote in message
...
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?