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

Please Login or Register  to view this content.

Regards Mick

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

and also

Please Login or Register  to view this content.

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.