Powerful: Get any relative date

There is a more powerful formula for those who need it: the getRelativeDate() formula allows you to do everything that Last(), This(), and Next() do, but also allows you to go back in time or forward in time further than 1 week.

Formula example

Parameters

⁠

In-use

⁠

See it in action

Select a start date:

2/24/2022

⁠

Select week index:

⁠

000

⁠

Select a result day:

⁠

Saturday

⁠

The

Saturday

⁠

of the week

9

⁠

weeks

after

⁠

your start date:

4/30/2022

⁠

2️⃣ Check your work

2️⃣ 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.