Date validation out of 3 different cells

[rgiglio7489]

Hi- I was wondering if its possible to do the following:

I am using 3 Cells: A1, B1 and C1. Each cell is a drop down list (data validation), so the user can choose and option. A1 being the Month, B1 being the Day and C1 being the year. Is it possible to validate the selections, and make sure the date that is entered is a valid date?

For example, using the drop down list, a user has the ability to put in February 31, 2014 and submit the form... this date clearly does not exist.

Is it possible to validate the date they enter in this situation?

I tried stringing the cells together in cell D1, while simultaneously validating whether or not the date in D1 exists... this did not work... any ideas?

Is the best way to potentially embed a macro in the submit button that first validates the date and then if True, the form is submitted. And if False, a message box advises the person submitting the form to edit the date?

PS: I would prefer to use a formula/validation rather than VBA... this file already has enough VBA in it.

[JieJenn]

Maybe look into the DATEVALUE Function. Here's an example on how you can validate the date.

=IFERROR(DATEVALUE(A2&"/"&B2&"/"&C2),"Not a correct date format")

[rgiglio7489]

Thanks for the idea... went a different way, but used your formula