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

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?

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

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?

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

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

"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?

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

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?