MONTHNAME

Returns the English name of the month of a specific date.  (For example, whether a specific date is in January, February, March, April, ….., or December.)

Syntax

MONTHNAME(year_input, month_input, day_input, short_name)

year_input - the 4-digit year to be considered.
month_input - the month (in numeric format) to be considered.
day_input - the day to be considered.
short_name - Optional.  Boolean, either TRUE or FALSE.  Function returns the short name if TRUE, long name if FALSE.  Default value is FALSE if omitted.

Example

MONTHNAME(2005, 6, 9) returns “June”.
MONTHNAME (2005, 6, 9, TRUE) returns “Jun”.

See Also

DAYNAME