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!