How To Calculate Fiscal Quarter Based on Date in Excel/Sheets + Free Template

Oftentimes a fiscal year does not start on January first and companies will want data summarized by the fiscal quarter start. This can be done with a quick formula using CHOOSE in either Microsoft Excel or Google Sheets.

Steps to Extract Fiscal Quarter from Date

1. Format your date that you are trying to extract the fiscal quarter to mm-dd-yyyy
2. Create a column that specifies what quarter the fiscal quarter starts:
   1. Example: If your fiscal quarter starts in October add 1 to that column
3. Utilize the CHOOSE function to extract the fiscal quarter as follows:
   1. =”Quarter ” & CHOOSE(MONTH(A2),1,1,1,2,2,2,3,3,3,4,4,4)
      1. Quarter will add the text “Quarter” before the number, omit if you do not wish to see this text
      2. Point cell A2 to the column where you have specified the quarter start for your fiscal year

Free Template – Copy to Extract Fiscal Quarter

Download the template here that you can easily copy and paste into an existing sheet or workbook to graph your own data by fiscal quarter.

What is in the template for fiscal year extraction

• This template provides examples and formulas for fiscal years starting from each month.
• No need for you to recreate the formula you will just need to copy and paste!

How to use the template for fiscal year

• Change the start of the month number for your specific fiscal quarter
• Example if January is the start month of your fiscal year
  • 1 = January, 1 = February, 1 = March, 2 = April, 2 = May, 2 = June, 3 = July, 3 = August, 3 = September, 4 = October, 4 = November, 4 = December
• Example if April is the start month of your fiscal year
  • 4 = January, 4 = February, 4 = March, 1 = April, 1 = May, 1 = June, 2 = July, 2 = August, 2 = September, 3 = October, 3 = November, 3 = December
• Example if July is the start month of your fiscal year
  • 3 = January, 3 = February, 3 = March, 4 = April, 4 = May, 4 = June, 1 = July, 1 = August, 1 = September, 2 = October, 2 = November, 2 = December
• Example if October is the start month of your fiscal year
  • 2 = January, 2 = February, 2 = March, 3 = April, 3 = May, 3 = June, 4 = July, 4 = August, 4 = September, 1 = October, 1 = November, 1 = December

What date range is in the template

• The dates start from 1/1/2020 through 12/31/2028.
• Once you make a copy of the template you will be able to modify it for your own needs.

Download Free Template to Extract Fiscal Quarter