Clear Info after 7 days

[Elengil]

Having trouble with a task for work. They've asked for a simple spreadsheet that clears all data in cells D4-Z40 after 7 days so they can fill in a blank one for the following week and track maintenance jobs? Probably be a VBA thing needed to do it as I can't figure out or find a formula to help barring a rule that sets them blank which isn't really a fix???

 

[Micron]

Not sure I completely follow. I think you want to clear cells that have data entries but there are no formulas in them. Could use vba for sure. Could also just select D40 and in the address box, add :Z40 to it and hit enter. That will select that range. Then press delete. If you want it to happen automagically based on Today() vs some date, then might need a helper cell with that date (e.g.B1). Or you could just take action if B4 contains a date that is 7 days ago or greater. Seems kind of dangerous to let the system do that automatically. Imagine opening wb Monday morning to enter Friday afternoon data only to find it's all gone whether you wanted that or not.