Skip to content
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
Bonus: More relative date formulas

Due to popular request, I’ve added two more formulas to the Pack: PreviousPeriod(), which can get a usable date range for either the previous period or the previous year, and MonthsBetween(), which can get the number of months between two dates.

Formula examples

Previous period

⁠
image.png
⁠
⁠
Click the image to see the syntax

Months between

⁠
image.png
⁠
⁠
Click the image to see the syntax
⁠

See it in action


Select a date range:
March 2 - June 30, 2022
⁠
⁠
Select a previous period:
Previous period
⁠
⁠

Previous period

⁠
11/1/20213/1/2022
⁠
⁠

⁠
⁠
⁠

Months between

⁠
4
⁠
⁠


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.