Covert date to fiscal quarter in Excel

Posted on:  01/27/2019
Covert date to fiscal quarter in Excel
We frequently look at quarterly data. If you want to calculate the fiscal quarter from a date, possibly an invoice date or an order date, and the fiscal quarter starts in a month other than January, use the CHOOSE function. For instance, if the fiscal year is from July to June, you would use a formula based on the CHOOSE function in Excel to get the fiscal quarter. 
 
To calculate the quarter when the fiscal year and fiscal month are in January, you can use the ROUNDUP and MONTH functions together. It is easier than CHOOSE and MONTH functions. Here is a screenshot of ROUNDUP and MONTH. 

=ROUNDUP(MONTH(B2)/3,0)

CHOOSE Function in Excel

The CHOOSE function is an important function, but not frequently used. Here is a great example of when to use it. I have four car companies: Ford, GM, Nissan, and Kia. If I use the CHOOSE function and type =CHOOSE (2,"Ford","GM","Nissan","Kia") the answer is GM since GM is listed second. The same function but now 3 would give me Nissan as the answer. =CHOOSE (3, "Ford","GM","Nissan","Kia"). Nissan is the third company listed. 

Last example, =CHOOSE(3,"North","East","South","West") would produce South since South is the 3rd region listed.

Excel file with CHOOSE Function

File used in the YouTube video


YouTube video on the CHOOSE Function

Chris Menard's Snagit Webinar on January 29, 2019

More Information on the webinar, click here.

Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories