CF_MONTHNAME
Feature available from Bizview version - Bizview 5.0
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.