Show blank when today() is within a certain date range

[Sarah (OGI)]

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?

 

[Mike H]

Sarah,

Try this:-

=IF(TODAY()-C90>30,"","What figure would you like ?")

 

[Mike H]

What I should have done is read you post correctly and then I would have done
this instead:-

=IF(TODAY()<=EOMONTH(C90,1),"","What figure would you like ?")

This requires the analysis tool pack addin. Tools|Addins|analysis toolpack

Mike

 

[Roger Govier]

Hi Sarah

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