Verify The accuracy of a date

[andrewb90]

Hello all,

I have a user form which the date is selected from 3 different dropdown boxes (month, day, year)... Those values are then entered into my sheet in C3:5.
My problem is that someone could in theory plan something for "June 31st" or February 30th" for example. Is there an effective way to validate that the date chosen does actually exist prior to moving forward with my userform?

Thanks,
Andrew

 

[RoryA]

You can try and convert the date to a Date value using CDate. If an error occurs, it is not a valid date.

 

[thisoldman]

Try testing the date string with IsDate(). Here's results from the Immediate Window.

? IsDate("02/29/2016")
True
? IsDate("02/29/2017")
False
? IsDate("6/30/2018")
True
? IsDate("6/31/2018")
False

 

[andrewb90]

Now the values appear in separate cells though:

C3: May
C4: 1
C5: 2018

So I would have to combine into a date value first?