display cell content based on date criteria

[hsg]

My worksheet contains several columns of data, first column being DATE.
each day new information is filled in column B to K, but in Column A, all
the dates
are already filled up, say 1 Jan 2009 to 31 Dec 2009.

I want that a date should not be visible before that date actually arrives,
i.e. on 5th jan, I should see on first 5 rows (jan 1 to jan5)

On 30th Dec, I should see all rows from Jan 1 to Dec 30, but not Dec 31.

Is is possible ?

 

[Jacob Skaria]

In cell A2 enter the first date...Enter the below formula in A3 and copy down
as required..

=IF(A2<>"",IF(A2+1<=TODAY(),A2+1,""),"")

 

[David Biddulph]

Format/ Conditional Formatting/ Cell value is/ greater than: =TODAY()
Select a white font (or colour equal to you background colour).