Skip to content
Gallery
Get a date relative to any start date
Get a date relative to any start date
Quick: Get dates from this, last, or next week
Powerful: Get any relative date
Bonus: More relative date formulas
More
Share
Explore

icon picker
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
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
⁠

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.