Explanation
The choose function uses the first argument to “select” remaining elements.
This works for fiscal years with a January start.
The values provided to CHOOSE can include references.
Get fiscal quarter from date
If you want to calculate the fiscal quarter from a date, and the fiscal quarter starts in a month other than January, you can use a formula based on the CHOOSE function. Note: if you just need to calculate a "normal" quarter based on a quarter system that starts in January, you can use this simpler formula. In the example shown, the formula in cell D5 is: =CHOOSE(MONTH(B5),4,4,4,1,1,1,2,2,2,3,3,3) This formula returns a number, 1-4 that corresponds to a quarter system that begins in April and ends in March.
