VBA Get Month Name From Date in Excel

VBA Get Month Name

Month plays an important role of a date. We can get month name from date in different ways. We can get month name using MonthName function and summarize data with it. Format name of the month by using format function.

VBA Get Month Name:

Let us see the procedure how to get name of the month from today’s date using MonthName function.

'Procedure to Get Month Name From Date
Sub VBA_Get_Month_Name()
    
    'Variable declaration
    Dim sMonth_Name As String
    
    'Retrieve month Name from date
    sMonth_Name = MonthName(Month("01/01/2018"))

    'Display month name
    MsgBox "If Date is "01/01/2018" then" & vbCrLf & _
    "Month name is : " & sMonth_Name, vbInformation, "Month Name From Date"
    
End Sub

Explanation: In the above procedure we have used Month, Date and MonthName VBA functions. Here Month function is used to display month number. MonthName function helps to generate name of the month from specified month number. Here is the output screenshot for your reference.

VBA Get Month Name

Format Name of the Month:

We have different format methods to format name of the month. You can find output in an immediate window.

'Format Name of the Month
Sub VBA_Format_Month_Name()
    
    'Variable declaration
    Dim sMonth_Name As String
    
    sMonth_Name = Format("01/01/2018", "m")
    Debug.Print sMonth_Name
    
    sMonth_Name = Format("01/01/2018", "mm")
    Debug.Print sMonth_Name
    
    sMonth_Name = Format("01/01/2018", "mmm")
    Debug.Print sMonth_Name
    
    sMonth_Name = Format("01/01/2018", "mmmm")
    Debug.Print sMonth_Name
        
End Sub

Output screenshot: Here is the output screenshot.
Format Month Name

Instructions to Run VBA Macro Code or Procedure:

You can refer the following link for the step by step instructions.

Instructions to run VBA Macro Code

Other Useful Resources:

Click on the following links of the useful resources. These helps to learn and gain more knowledge.

VBA Tutorial VBA Functions List VBA Arrays VBA Text Files VBA Tables

VBA Editor Keyboard Shortcut Keys List VBA Interview Questions & Answers Blog

Leave a Comment