ExcelBanter - Can I make information entered in a cell erase recurringly?

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

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

- - Can I make information entered in a cell erase recurringly? (https://www.excelbanter.com/excel-discussion-misc-queries/89432-can-i-make-information-entered-cell-erase-recurringly.html)

Conker10382

Can I make information entered in a cell erase recurringly?

I am trying to create a checklist that will refresh certain cells on spacific
days. For instance, If I enter "YES" in cells A1 and B1 on May 20th, I want
cell A1 to revert to a blank cell on June 15th, and cell B1 to revert to a
blank cell on June 18th. Is there a formula to cause this function?

All times are GMT +1. The time now is 11:03 PM.