Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

The Query Editor allows you to easily create Year, Month, Month Name etc, but many people need Fiscal Month Number and Fiscal year

46 votes

Wyn Hopkins shared this idea · May 3, 2017 · Flag idea as inappropriate… · Admin →

Accepting Votes ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · Mar 24, 2018

Thanks for logging this useful suggestion, Wyn.

Others browsing this, please be sure to add your vote to help us prioritize this item in our product backlog.

thanks

Ashvini Sharma
Lead Program Manager
Excel

4 comments

An error occurred while saving the comment

SamCal commented · January 29, 2020 9:31 PM · Flag as inappropriate

I have longed for fiscal year settings and fiscal year extensions to date functions. This suggestion would be a great start.

Submitting...
Anonymous commented · August 23, 2019 9:26 AM · Flag as inappropriate

I would extend this request to allow for sorting by Fiscal Year/Month. All of our financials and most of our deliverables are on FY schedules

Submitting...
Anonymous commented · September 3, 2017 10:05 AM · Flag as inappropriate

99% of my reports are fiscal year based

Submitting...
Matt Allington commented · August 22, 2017 4:49 AM · Flag as inappropriate

Nice idea

Submitting...