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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Testing a cell value for a specific weekday. 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
#Value in random cells 3
Formulas--NEED HELP! 4
Day formula 4
Date Command to Get the Sunday Before the First of the Month 6
Need help with Date/ and find most common denominator. 3
Time Sheet Summary 1

Top