Use Formula is:

=OR((DAY(F1)=1),(DAY(F1)=16))

for the validation rule in F1
--
Gary''s Student - gsnu200841


"John" wrote:

In a certain cell the user enters a date. I would like data validation to
accept the entry only if the day is the 1st or 16th of the month. How do I
do that?