Date deleting

[Bryan De-Lara]

Is it possible to have data self delete.
If say you go past a date the data deletes from a cell from the year before
on that date. i.e. 28 Feb. 2007's data will delete 28 Feb. 2008 and so on
each day we go past?


Bryan.

 

[Sandy Mann]

=IF(TODAY()>DATE(2008,2,28),"",<Your data>)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk