on the data validation chose for a list, define the range, and there put the
dates and N/A

hth
regards from Brazil
Marcelo

"LPS" escreveu:

I'm using Excel 2000 in Windows 2000. I would like to create a data
validation which allows 2 options: the first is a date that the user enters
and the second is the characters "N/A" if a date is not relevant. I know how
to restrict the entries to just dates or just text. My question is: Is it
possible to have both (or more than one) validation criteria at the same time
(as described above).?

Many thanks,
--
LPS