How about

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


"Gringarlow" wrote:

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