What would be the easiest way to capture the last Saturday that occurred? I want a particular cell to automatically update whenever I open it on Monday or Tuesday to bring the date of the most recent Saturday.

Thanks for all your help!
John