Quick: Get dates from this, last, or next week

This Pack has three formulas for getting the most common relative dates: For This() week, Next() week, or Last() week.
Formula examples
This week
image.png
image.png
Click the image to see the syntax
Next week
image.png
image.png
Click the image to see the syntax
Last week
image.png
image.png
Click the image to see the syntax
See it in action:

Select a start date:
2/24/2022
Select a weekday:
Saturday

Last
Saturday
2/19/2022

This
Saturday
2/26/2022

Next
Saturday
3/5/2022

Usage in a table
0
Search
Start date
Week before
Week of
Week after
1
1/22/2022
1/15/2022
1/22/2022
1/29/2022
2
4/17/2021
4/10/2021
4/17/2021
4/24/2021
3
10/20/2021
10/16/2021
10/23/2021
10/30/2021
There are no rows in this table
1️⃣ Check your work
0

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.