Thread: Dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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!