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

⁠

Click the image to see the syntax

Months between

⁠

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.