Hi,

Try this in a cell

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

Mike

Mike

"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