Oasis Solutions Blog

BizInsight Time Saver Tip - The Choose Function

Written by Oasis Solutions | Dec 9, 2014 5:16:18 PM

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