Drop data from workbook after specified time
 

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

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