Calculating Fiscal Quarter for a Date using CHOOSE ()

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)

Be the first to comment

Leave a Reply

Your email address will not be published.