Data Validation with Date and List

[patrykp]

I'm trying to have data validation for a column where users can either enter a date or pick from a list. The list will have three options, so that a column may look like:

A
1/1/11
Choice A
2/3/10
Choice C
3/15/08

etc...

I know I could create a long list that included dates and the choices, but the date ranges will vary over a 10 year span. Is there a way to custom code this?

It would be nice if the drop-down validations list had:
Choice A
Choice B
Choice C

but also didn't give an error if someone entered a date.

Thanks!

 

[Robert Mika]

Hi Patryk,
Welcome to the board.

Just for curiosity

If user can use own date why do you need the validation for?

You can use dependat dropdown list

Look here
http://www.contextures.com/xldataval13.html

 

[grizz]

you may want to check this site out ---- click on the 4th selection down

https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/files