You're welcome. Thanks for the feedback!

Biff

"tikchye_oldLearner57" wrote
in message ...
thanks :) T. Valko, much appreciated for your assistance

will try out the syntax

and to community as well, thanks !
--
oldLearner57


"T. Valko" wrote:

Try this:

=AND(WEEKDAY(A1,2)<3,WEEKDAY(A1,2)<6)

This will allow Mon, Tue, Thur, Fri and Sun

It will not allow Wed or Sat

Biff

"tikchye_oldLearner57"
wrote
in message ...
thanks T. Valko for your assistance.. :)
the syntax :
=weekday(a1,2)<6 is to avoid two day running one after another Saturday
or
Sunday...

my objective is...

example:

I set a range of cell with validation date format that only allow
Monday /
Tuesday / Thursday / Friday / Sunday...

and if user enter any date format that falls in Wednesday or Saturday,
the
cell entry does not permit it.

is it possible to do such validation ?

very much appreciated for the assistance render :)
--
oldLearner57


"T. Valko" wrote:

is possible to validate a date to avoid say Saturday or Sunday
whenever
a
user enter a date entry....

DataValidationAllowCustom
Formula: =WEEKDAY(A1,2)<6

is it possible to validate a week, say, whenever a user enter
Tuesday
and
Friday, the range do not allow it......

Don't know what you mean by that.

Biff

"tikchye_oldLearner57"
wrote
in message ...
hi community

is possible to validate a date to avoid say Saturday or Sunday
whenever
a
user enter a date entry....

is it possible to validate a week, say, whenever a user enter
Tuesday
and
Friday, the range do not allow it......

thanks community for ever helpful assistance :)


--
oldLearner57