---
title: BizInsight Time Saver Tip - The Choose Function
description: BizInsight Time Saver Tip - The Choose Function
image: https://blog.oasisky.com/hubfs/Imported_Blog_Media/1-1.png
---

[![Oasis Solutions](https://blog.oasisky.com/hs-fs/hubfs/2-1.png?width=300&height=150&name=2-1.png "Oasis Solutions")](http://oasis.solutions)

Search for:

[Help Desk](https://oasisky.com/help-desk/)

Search for:

[Help Desk](https://oasisky.com/help-desk/)

# BizInsight Time Saver Tip - The Choose Function

by [Oasis Solutions](https://blog.oasisky.com/author/oasis-solutions)  | Dec 9, 2014 | [News](https://blog.oasisky.com/tag/news), [Industry Insights](https://blog.oasisky.com/tag/industry-insights)  | [0 Comments ](https://blog.oasisky.com/blog/bizinsight-time-saver-tip-the-choose-function#comments-listing)

- [Tweet](https://twitter.com/share)

**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")

 

![1](https://blog.oasisky.com/hubfs/Imported_Blog_Media/1-1.png)

 

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 **](http://www.oasisky.com/contact)

### Categories

- [ERP (282)](https://blog.oasisky.com/tag/erp)
- [News (192)](https://blog.oasisky.com/tag/news)
- [Industry Insights (76)](https://blog.oasisky.com/tag/industry-insights)
- [Press Release (52)](https://blog.oasisky.com/tag/press-releases)
- [Oasis Team (48)](https://blog.oasisky.com/tag/oasis-team)
- [Our Partners (27)](https://blog.oasisky.com/tag/our-partners)
- [Best Practices (22)](https://blog.oasisky.com/tag/best-practices)

[See all](https://blog.oasisky.com/blog/bizinsight-time-saver-tip-the-choose-function#)

### Recent Posts

![Oasis Solutions](https://blog.oasisky.com/hubfs/Oasis_Solutions_January2019/Images/footer-rev-logo@2x.png)

#### [Connect With Us](https://oasisky.com/contact)

- Headquarters
- [Louisville, KY 40222](https://oasisky.com/louisville-kentucky-hq/)
- [Phone: 502.429.6902](tel:15024296902)

- [Lexington, KY 40504](https://oasisky.com/lexington-ky/)
- [Nashville, TN 37219](https://oasisky.com/nashville)

- [Facebook ](https://www.facebook.com/OasisSolutionsGroup)
- [Twitter ](https://twitter.com/Oasisky)
- [YouTube ](https://www.youtube.com/channel/UCPk1-r7nnH9H8_xUF0Cdb8Q)
- [LinkedIn ](https://www.linkedin.com/company/oasis-solutions-group)

#### ERP

#### Business Intelligence

#### CRM

#### Other Solutions

#### About Oasis

#### Learn

[![Oasis Solutions Group BBB Business Review](https://seal-louisville.bbb.org/seals/blue-seal-200-130-bbb-6000955.png)](http://www.bbb.org/louisville/business-reviews/computer-software-publishers-and-developers/oasis-solutions-group-in-louisville-ky-6000955/#bbbonlineclick)

© 2025 Oasis Solutions

[Help Desk](https://oasisky.com/help-desk/)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Oasis Solutions",
    "url" : "https://blog.oasisky.com/author/oasis-solutions"
  },
  "dateModified" : "2019-04-08T20:31:16.404Z",
  "datePublished" : "2014-12-09T17:16:18.000Z",
  "headline" : "BizInsight Time Saver Tip - The Choose Function",
  "image" : [ "https://blog.oasisky.com/hubfs/Imported_Blog_Media/1-1.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.oasisky.com/blog/bizinsight-time-saver-tip-the-choose-function",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.oasisky.com/hubfs/Oasis-logo-vertical-multi-black-1.png"
    },
    "name" : "Oasis Solutions"
  }
}
```