Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |