Drop data from workbook after specified time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Peculiar default cell format 1
I'm trying to include a cell reference as part of an ext. link 4
SUMIF result including values not specified in sum-range 2
Formatted cell column in drop down list 1
new data 1
Excel Move or Copy Stopped Working? 0
Drop down box issue 2
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6

Back
Top