Forum Discussion
Solved
how do i change the default fiscal year in excel
Microsoft automatically identifies the quarters in a fiscal year that starts in January. My fiscal year starts in November; how can I change the automatic fiscal year to fit this?
Niko, that link is for Microsoft Project, not for Excel. As far as I know, Excel does not have a built-in concept of fiscal year.
You can change the default fiscal year in Excel by following these steps:
Choose File > Options, and then select Schedule.
In the Fiscal year starts in box, select the month with which you want the fiscal year to start.
If you want to label the fiscal year by using the calendar year in which that fiscal year begins (rather than the calendar year in which it ends), select the Use starting year for FY numbering check box.
I hope this helps!
Niko, that link is for Microsoft Project, not for Excel. As far as I know, Excel does not have a built-in concept of fiscal year.