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.
Bookmarks