Cell Should always be the most recent Saturday

G

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
 
M

Mike H

Hi,

Try this in a cell

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

Mike

Mike
 
Top