Rolling Tracker - Auto delete cells as a date is past

I have been trying to create a tracker for absence / sickness that rolls over 52 weeks.

I cant work out how to set a formula to delete a whole line of data as a date passes. My spreadsheet automatically deletes the date from column A fine, but not the data that refers to the past date from columns b,c,d and so on.

Is it possible to set a formula to remove a whole line of data as a date passes. Sickness Tracker Rolling 52 Weeks.xls

A formula cannot delete a row - it just returns a result. You would need to use VBA to do that, or a manual process whereby you could indicate with a formula that a row should be deleted if the date has passed, and then you need to delete it yourself.

Hope this helps.

Pete

Thanks Pete, I don't know much about VBA so I think may have to go down a manual process.