Cell Should always be the most recent Saturday

[Gringarlow]

How could I make a cell be equal to the most recent Saturday, no matter what
day or time I open the work book?
I update my data weekly, with the week ending on Saturday, so when the
workbook in question is opened I want to show the date of the latest update.
Thank You

 

[Mike H]

Hi,

Try this in a cell

=TODAY()+CHOOSE(WEEKDAY(TODAY()),-1,-2,-3,-4,-5,-6,0)

Mike

Mike

 

[mikebres]

How about

=TODAY()-MOD(TODAY(),7)