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.)


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.


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

See Also