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)