How to Set a February Fiscal Year in an Excel PivotTable with WPS Spreadsheets
Question details
The user needs to group PivotTable dates into fiscal quarters and years when the fiscal year starts in February, using helper columns or the Excel Data Model.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has a date column in a PivotTable and needs quarterly and yearly grouping aligned to a February fiscal year.
- Observed behavior
- Default PivotTable date grouping follows the calendar year, so February-start fiscal quarters and years are not grouped correctly.
Confirm that the date column contains real date values rather than text, and decide whether you will create helper columns in the worksheet or use a Data Model calendar.
Create February Fiscal Quarter and Year Helper Columns in WPS Spreadsheets
Use this when you want the quickest, formula-based method that works directly in the current PivotTable.
Because a February fiscal year shifts the date sequence by one month, EDATE(D2,-1) moves each date back to a January-based equivalent. The formulas then calculate the quarter and fiscal year from that adjusted date.
Open your workbook in WPS Spreadsheets and click E2, or the first empty cell immediately to the right of your date column, for example if dates are in D2:D.
Type =QUOTIENT(MONTH(EDATE(D2,-1))-1,3)+1 and press Enter. To display Q1–Q4 instead of numbers, use ="Q""IENT(MONTH(EDATE(D2,-1))-1,3)+1.
Click the next empty cell in the same row, type =YEAR(EDATE(D2,-1)), and press Enter.
Select both formula cells, then drag the fill handle down through the last date row to apply the fiscal calculations.
Click the PivotTable, open the PivotTable Fields panel, and add the new fiscal year and fiscal quarter columns to the Rows or Columns area.
Use a Custom Fiscal Calendar in the Excel Data Model for Advanced Reporting
Use this for advanced time intelligence and reports that need many fiscal measures without helper columns in the source table.
Set a February Fiscal Year in PivotTables with WPS Spreadsheets Helper Columns
Open your Excel workbook in WPS Spreadsheets and use two simple EDATE-based helper columns to group PivotTable dates into February-start fiscal quarters and years—no complex configuration required.
- 1. Open the workbook: Open your Excel workbook in WPS Spreadsheets and click the cell to the right of the first date, such as E2.
- 2. Create the fiscal quarter column: Type =QUOTIENT(MONTH(EDATE(D2,-1))-1,3)+1 and press Enter to calculate the February-start fiscal quarter.
- 3. Create the fiscal year column: In the next empty cell, type =YEAR(EDATE(D2,-1)) and press Enter to calculate the February-start fiscal year.
- 4. Fill the formulas down: Select both formula cells and drag the fill handle down through the last date row.
- 5. Update the PivotTable: Click the PivotTable, open PivotTable Fields, and add the new fiscal year and fiscal quarter fields to reorganize the report.
Frequently Asked Questions
Does this fiscal year method work in WPS Spreadsheets?
Yes. WPS Spreadsheets supports EDATE, MONTH, YEAR, and QUOTIENT, so you can enter the helper-column formulas in the same way as Excel.
Why does the formula use EDATE(D2,-1)?
It shifts each date back one month so February becomes month 1, allowing the quarter and year calculations to start from February instead of January.
How do I show Q1, Q2, Q3, and Q4 instead of numbers?
Use ="Q""IENT(MONTH(EDATE(D2,-1))-1,3)+1 as the fiscal-quarter formula, then add that text field to the PivotTable.
Can I group the date field directly in the PivotTable without helper columns?
Standard PivotTable date grouping follows the calendar year. For a February fiscal year, use helper columns or a Data Model custom calendar.
What should I do when new dates are added later?
Extend the fiscal formulas down to the new date rows, then refresh the PivotTable or update its data source.
