Pivot table - change the fiscal period to start in Feb instead of Jan

Copper Contributor

The pivot table defaults to Q1 being Jan, Feb, Mar and Q2 being Apr, May, June etc...


Is there a way to change it so that Q1 is Feb, Mar, Apr and Q2 is May, June, July etc...


My company's fiscal year starts in Feb. This is killing me in Excel...there must be a setting somewhere to tell Excel my fiscal start month is Feb.

2 Replies


Let's say you have dates in D2 and down.

Insert a new column next to column D.

In E2, enter the formula


to return the quarter as a number 1, 2, 3, 4, or


to return it as text Q1, Q2, Q3, Q4.

Use the new column in the pivot table.


For the fiscal year you can insert another column with formula



Fill down to the last data row.


If in Excel you work with data model, here is the pattern how to work with non-standard fiscal years Custom time-related calculations – DAX Patterns