One way
=IF(A1<NOW()-28,"",B1) with the date of the entry in A1 and the data in B1.
It doesn't actually drop the data, but eliminates it from the cell display.
--
Ian
--
"yardcow" wrote in message
...
I want to include a formula that will drop data from worksheets that keep a
running total when the data becomes over 4 weeks old.
--
yardcow
|