Dates

[lightbulb]

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!

 

[Sheeloo]

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(A1>DATE(2009,5,1),A1<DATE(2009,6,1)),"Within range","Out of range")
or
=IF(AND(A1>DATE(2009,5,1),A1<DATE(2009,6,1)),A1,"")

 

[Gary''s Student]

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.

 

[David Biddulph]

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