display cell content based on date criteria
 

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 ?

display cell content based on date criteria
 

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,""),"")

--
Jacob


"hsg" wrote:

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 ?

display cell content based on date criteria
 

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

"hsg" wrote in message
...
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 ?