MonthName(Month(Date)) : MonthName « Date Functions « VBA / Excel / Access / Word






MonthName(Month(Date))

 
Sub Main6()
   Debug.Print "Today's date is: " & Date
   Debug.Print "The name of the month is: " & MonthName(Month(Date))
End Sub

 








Related examples in the same category

1.MonthName returns the text string associated with a month number:
2.MonthName(month) returns A String containing the name of the month represented by month
3.MonthName(Month(Date), True)