MonthName returns the text string associated with a month number: : MonthName « Date Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Date Functions
  3. MonthName

MonthName returns the text string associated with a month number:

 
Sub MonthNameExample()
    Debug.Print MonthName(7)
    'Returns July
    Debug.Print MonthName(11)
    'Returns November
End Sub








Related examples in the same category

1.MonthName(month) returns A String containing the name of the month represented by month
2.MonthName(Month(Date))
3.MonthName(Month(Date), True)