Drop data from workbook after specified time

Y

yardcow

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.
 
I

Ian

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.
 
Top