Category: Date and Time function

This function returns the abbreviated (3-letter) name of the month corresponding to the month_num, from 1 to 12.

Return value type: Text (Jan, Feb, Mar, etc.)

Passing in a value of less than 1, or greater than 12, results in an error message.

monthname(1)  //Returns 'Jan'

monthname(9)  //Returns 'Sep'

monthname(0)  //Returns '#Inappropriate argument for MonthName(number)'

• Month(date_as_number)
• MonthEnd(date)
• MonthNameLocal(month_num)
• MonthStart(date)