BizInsight Time Saver Tip – The Choose Function

How to: Use the CHOOSE function to assist in Creating Dynamic BizInsight Column Headers for the Month

1.      Enter your company, fiscal year and fiscal period into your worksheet, as required.  For this example, our fiscal period reference is located in cell B3

2.      In the cell where you want to note your current month, use the following CHOOSE function:

=CHOOSE($B$3,”January”,”February”,”March”,”April”,”May”,”June”,”July”,”August”,”September”,”October”,”November”,”December”)

 

This expression works if your fiscal year is the calendar year.  It takes the period number listed in B3, then finds that position in the list and returns that value.  So for period 11, it would look for the 11th value listed, and it would subsequently return “November”.

If your fiscal year started in month other than January, your list would begin with that month’s name.  If they fiscal year begins in June, for example, your CHOOSE function would look like this:

=CHOOSE($B$3,”June”,”July”,”August”,”September”,”October”,”November”,”December”,”January”,”February”,”March”,”April”,”May”)

 

Need help? Contact Us 

You may also like

Oasis Solutions is proud to be recognized as the Fall 2025 NetSuite Solution Provider Spotlight Winner in the Automotive Industry ...
Oasis Solutions is honored to be named to Accounting Today's 2025 Top 100 VARs list—recognizing excellence in ERP and accounting ...

Stay tuned on our ERP path!

Subscribe to our newsletter and get the latest news