Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

CF_MONTHNAME

The CF_MONTHNAME function can be used to quickly convert a month number to month name in text. This function is available from BizView version 5.0.

Enter the formula =CF_MONTHNAME("<date>";"<culture>")

The following parameters need to be defined:

  • A date or a cell reference (or named range) to a date within quotation marks (e.g. "20130521").

    • Date can be sent into the formula in the following formats:

      • 1-12

      • 01-12

      • YYYYMM

      • YYYYMMDD

      • YYYY-MM-DD

  • A culture ID within quotation marks (e.g. "sv-SE" to return the month name in Swedish). This parameter can be left out and then the defined culture for the user/client or application will be used.

Example

=CF_MONTHNAME("20130521";"en-US") will return the value "Jan".

=CF_MONTHNAME("01-13";"sv-SE") will return the value "january".

Note: The separator in the formula depends on the culture you are using in the application. "," for en-US, ";" for sv-SE, and so on.

Published:

CF_MONTHNAME

The CF_MONTHNAME function can be used to quickly convert a month number to month name in text. This function is available from BizView version 5.0.

Enter the formula =CF_MONTHNAME("<date>";"<culture>")

The following parameters need to be defined:

  • A date or a cell reference (or named range) to a date within quotation marks (e.g. "20130521").

    • Date can be sent into the formula in the following formats:

      • 1-12

      • 01-12

      • YYYYMM

      • YYYYMMDD

      • YYYY-MM-DD

  • A culture ID within quotation marks (e.g. "sv-SE" to return the month name in Swedish). This parameter can be left out and then the defined culture for the user/client or application will be used.

Example

=CF_MONTHNAME("20130521";"en-US") will return the value "Jan".

=CF_MONTHNAME("01-13";"sv-SE") will return the value "january".

Note: The separator in the formula depends on the culture you are using in the application. "," for en-US, ";" for sv-SE, and so on.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk