Cell Should always be the most recent Saturday
 

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

Cell Should always be the most recent Saturday
 

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

Cell Should always be the most recent Saturday
 

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