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.

=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 Removed)
Replace @mailinator.com with @tiscali.co.uk


"Bryan De-Lara" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>