Capturing the last "Saturday"

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

If you mean the Saturday 0 to 6 days ago, then

= TODAY() - WEEKDAY(TODAY() - 12, 3)

If you mean the Saturday 1 to 7 days ago, then

= TODAY() - 1 - WEEKDAY(TODAY() - 13, 3)

Hi SHG,

Thanks for the help! I actually ended up using: =TODAY()-MOD(TODAY()-7,7). Both work just as well though.

Thanks,
John