↙️

Return Fiscal Quarter From Date

Master Tag
Workplace
Created
Feb 10, 2020 01:04 PM
Usage
Month
Less Than
Greater Than
Start
Web Tags
Database
Formula
Alternatives
Cover
↙️
This tutorial will make systems that run on a quarterly basis return a fiscal quarter from a single or range of dates. In Notion, this can be accomplished with the IF and month functions. I will also demonstrate how to return bi-annual and monthly values from a date.
⚠️
January always returns the value 0 and February returns 1, March is 2 and so on.
Products W/ The Highest Return
Name
Revenue
Date
Quarter
Bi-Annual
Short Form (Update)
$7,356.00
Jul 1, 2019 → Jul 31, 2019
$4,980.00
May 15, 2019 → Jun 15, 2019
$4,765.00
Oct 1, 2019 → Oct 31, 2019
$4,459.00
May 15, 2019 → Jun 15, 2019
$4,167.00
Feb 1, 2019 → Feb 28, 2019
$3,945.00
Aug 15, 2019 → Sep 15, 2019
$3,673.00
Sep 1, 2019 → Sep 30, 2019