Retrieve last day of the month but hitting error

Hi,

I have month and year in the worksheet where I allowed user to select Month and Year and I wanted to retrieve last day of the Month+Year selected.
see below codes
Dim Month As String
Dim Year As String
Dim EndDate As Date

Month = Range("B1").Value 'July
Year = Range("D1").Value '2014

EndDate = DateValue((Month + 1) & "/1/" & Year) - 1

Hitting runtime error '13' : Type mismatch. What am I doing wrong? Please help.

If you month "July" in "B1" is a string then ,Perhaps

Sub MG04Sep49
Dim MyMonth As String
Dim Year As String
Dim EndDate As Date
Dim Mth As Integer
    MyMonth = Range("B1").Value 'July '
        Year = Range("D1").Value '2014
            Mth = Month("01-" & MyMonth & "-" & Year)
                EndDate = DateAdd("d", -1, DateSerial(Year, Mth, "1"))
End Sub

Regards Mick

If you month "July" in "B1" is a string then ,Perhaps

Sub MG04Sep49
Dim MyMonth As String
Dim Year As String
Dim EndDate As Date
Dim Mth As Integer
    MyMonth = Range("B1").Value 'July '
        Year = Range("D1").Value '2014
            Mth = Month("01-" & MyMonth & "-" & Year)
                EndDate = DateAdd("d", -1, DateSerial(Year, Mth, "1"))
End Sub

Regards Mick

Hi all,
Thanks for your reply. Sorry it's my first time posting. Will take note of that.

I'm hitting error type mismatch for both codes below. Month and Year is a String. I'm using Excell 2011 on Mac. Is that the problem?

I tried

                 EndDate = WorksheetFunction.EoMonth(DateSerial(CInt(Year), CInt(Month), 1), 0)

and also

Sub MG04Sep49
Dim MyMonth As String
Dim Year As String
Dim EndDate As Date
Dim Mth As Integer
    MyMonth = Range("B1").Value 'July '
        Year = Range("D1").Value '2014
            Mth = Month("01-" & MyMonth & "-" & Year)
                EndDate = DateAdd("d", -1, DateSerial(Year, Mth, "1"))
End Sub

I'm not familar with "Mac's " and Excel, although it may be the case.
I can only suggest you open the VB Code Window and step through the code (Clicking "F8") to see where it fails.
If you click help in the Vb Code Window I imagine you can see if those Functions like "Month" and "DateAdd" are supported.