ExcelBanter - how do I delete a row automatically after each date ends

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I delete a row automatically after each date ends (https://www.excelbanter.com/excel-discussion-misc-queries/123261-how-do-i-delete-row-automatically-after-each-date-ends.html)

delete automatically

how do I delete a row automatically after each date ends

Is it possible to have a row in excel be deleted automatically after todays
date is over?. For example, when today is over and the next time they open
excel tomorrows date is on the top row. This way they don't have to scroll
down until they find the date to see what there schedule to work?

All times are GMT +1. The time now is 05:42 PM.