Change Cell Values @ 12:01AM Each Monday

Hello Everyone,

I have an employee who will be checking that a certain task was completed during the previous week. They will enter "Yes" or "No" on a spreadsheet.
I have the dates in an adjacent column set to update automatically when a new week begins, but I haven't found a way to make it so the Yes/No cells are cleared (blank, no value) every Monday before we come to work. Thoughts?

Thanks!

Here's the example. The dates on the right section are set to update with the Monday/Friday dates of the previous week, but if the Yes/No/Incomplete values remain it could cause confusion and lead people to believe that the work was already completed.

There are two separate people performing two different types of checks within the workbook each week, but another 10-ish people will be viewing it on a regular basis (it's supposed to act as an inspection tracker for all of the equipment at our facility).

I use desktop Excel, and I imagine that the people updating it also use Excel. The document does exist within SharePoint so there is a chance someone may try to update it through a browser version.

Is there a way that I can use conditional formatting to highlight data that hasn't been updated during the current week? I don't necessarily need the cells to be emptied weekly, I just need to be able to identify when the information within them is outdated.

Here's a snapshot of what that section currently looks like.

My bad, I thought the previous posts made it clear but I'll give more detail.

We perform weekly inspections on machinery. The forms for the past week get turned in to the office the following Monday.

I want to make it as hands-off as possible for the people recording whether or not each of the forms was completed last week.
The "Week Start" and "Week End" columns are set to always display the previous week's Monday and Friday dates.

The problem with that is, when I come in on Monday morning the dates will be updated, but the Yes/No/Incomplete information from last week will still be there and potentially lead people to believe that the task of inputting that data has already been completed.

I just need those values to be empty or clearly identifiable as old data every Monday when I come in.

I was hoping there would be a formula solution to say that if today is Sunday, empty the cells. Sounds like it won't be that simple.

Thanks for your insight everyone!

It seems that it's always the simple things that are unattainable. Oh well, I'll just set an alarm to delete the cells manually.