=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!