How to calculate quarterly values in Excel

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.