What would be the easiest way to capture the last Saturday that occurred? I want a particular cell to automatically update whenever I open it on Monday or Tuesday to bring the date of the most recent Saturday.
Thanks for all your help!
John
What would be the easiest way to capture the last Saturday that occurred? I want a particular cell to automatically update whenever I open it on Monday or Tuesday to bring the date of the most recent Saturday.
Thanks for all your help!
John
If you mean the Saturday 0 to 6 days ago, then
= TODAY() - WEEKDAY(TODAY() - 12, 3)
If you mean the Saturday 1 to 7 days ago, then
= TODAY() - 1 - WEEKDAY(TODAY() - 13, 3)
Hi SHG,
Thanks for the help! I actually ended up using: =TODAY()-MOD(TODAY()-7,7). Both work just as well though.
Thanks,
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks