View Single Post
  #2   Report Post  
Ian
 
Posts: n/a
Default

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