Convert month name into number Convert month name into number vba vba

Convert month name into number


excel date vba

Another way

Excel Formula

=MONTH(1&A1)

VBA

Sub Sample()    Dim MonthNm As String    MonthNm = "September"    Debug.Print Month(DateValue("01 " & MonthNm & " 2012"))End Sub

or 

Sub Sample()    Dim MonthNm As String    MonthNm = "September"    Debug.Print Application.Evaluate("=MONTH(1&" & Chr(34) & MonthNm & Chr(34) & ")")End Sub

Replace

excel date vba

Try this...

 =MONTH(DATEVALUE(A1&"1"))

Where A1 cell contains month name.

excel date vba 

Sub month()Dim monthh As Integermonthh = month(Date)MsgBox monthhEnd Sub

try this.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last