By convention a fiscal year is denoted by the year in which it ends.

The zero has no effect, so the final result is 2017.

This increments the year by one.

Excel formula: Get quarter from date

Note: withboolean logic, TRUE values are evaluated as 1 and FALSE values are evaluated as zero.

If not, the expression returns FALSE, or zero.

Excel formula: Get fiscal quarter from date

Excel formula: Sum by fiscal year

Excel MONTH function

Excel YEAR function