Dates
 

Is there a way to have a formula look at a cell and if the date in that cell
is between two certain dates to display it, otherwise leave blank...for
example:

2/15/2009

I want a formula to display the above date if it is equal to or between
2/8/2009 & 2/15/2009

Any ideas?

Thanks!

Dates
 

You can check the date in one cell and display it in another only if it is
between two dates but you can not use a formula in the same cell...

You may use conditional formatting with white FONT as a workaround.

You can have theis formula in B1 to check dates in A1
=IF(AND(A1DATE(2009,5,1),A1<DATE(2009,6,1)),"With in range","Out of range")
or
=IF(AND(A1DATE(2009,5,1),A1<DATE(2009,6,1)),A1,"" )

"lightbulb" wrote:

Is there a way to have a formula look at a cell and if the date in that cell
is between two certain dates to display it, otherwise leave blank...for
example:

2/15/2009

I want a formula to display the above date if it is equal to or between
2/8/2009 & 2/15/2009

Any ideas?

Thanks!

Dates
 

First format the cell to have the same font color as background color (say
both white). Then:

Format Conditional formatting... Cell value is between 39852 and 39859
and specify a black font color.
--
Gary''s Student - gsnu200854


"lightbulb" wrote:

Is there a way to have a formula look at a cell and if the date in that cell
is between two certain dates to display it, otherwise leave blank...for
example:

2/15/2009

I want a formula to display the above date if it is equal to or between
2/8/2009 & 2/15/2009

Any ideas?

Thanks!

Dates
 

=IF(AND(A2=DATE(2009,2,8),A2<=DATE(2009,2,15)),A2 ,"") and format the cell
appropriately.
--
David Biddulph

"lightbulb" wrote in message
...
Is there a way to have a formula look at a cell and if the date in that
cell
is between two certain dates to display it, otherwise leave blank...for
example:

2/15/2009

I want a formula to display the above date if it is equal to or between
2/8/2009 & 2/15/2009

Any ideas?

Thanks!