Hi Friends, today we will learn * How to Calculate the Fiscal Quarter for a Date*. For Lot of Companies, the Fiscal year doesn’t start in January but it starts in April & the month of April becomes Q1 of Fiscal Calender. Refer below:

Now suppose we have been given a set of arbitrary dates & the required result is Q1,Q2,Q3 or Q4 as per above table.

For this we will use CHOOSE () function, the CHOOSE function returns an answer from a list of choices based on Position number.

Example: =CHOOSE (1,”good”,”average”,”bad”) returns good as a result & if instead of 1, we use 2 we would get average as the result.

Finding-Fiscal-Quarter-Based-on-a-date.xlsx (28 downloads)

## Leave a Reply