Quarterly Excel value expression
Excel doesn't have a built-in format that displays where a date falls into the quarter system. If you need a date's quarter, use the following expression:
Since the expression both subtracts and then adds 1, you might think you can eliminate both steps, but you can't. The expression can't handle the last month in each quarter.