Fiscal years are different than calendar years. To quickly convert any date to it's fiscal attributes, use Fiscal Date Functions. Functions include FISCALYEAR, FISCALQTR, and WEEKDAYNAME. Allowing you to analyze data and create reports based on fiscal year.
By:
Works with:
2K+
Overview
Fiscal years are different than calendar years.  To quickly convert any date to it's fiscal attributes, use Fiscal Date Functions.

Functions include FISCALYEAR, FISCALQTR, and WEEKDAYNAME.  Allowing you to analyze data and create reports based on fiscal year.
Additional information
PricingNot available
Developer
Trader status unspecified
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
Fiscal Date Functions will ask for the permissions shown below. Learn more
Fiscal Date Functions will need access to your Google account
This will allow Fiscal Date Functions to :
See, edit, create, and delete all your Google Sheets spreadsheets
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Matthew Gray
July 20, 2022
So far it does exactly what I want! Allows me to generate pivot table reports based on Fiscal Years. Will update review if there is any change or feedback.
Is this review helpful?
Yes
No
Profile Picture
Ujjal Agarwal
June 1, 2022
Arrayformula does not work in the formula.
Is this review helpful?
Yes
No
1-2 of 2
Search
Clear search
Close search
Google apps
Main menu