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.