validate alternate day date

[Guest]

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

 

[T. Valko]

is possible to validate a date to avoid say Saturday or Sunday whenever a

user enter a date entry....

Data>Validation>Allow>Custom
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

 

[Guest]

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

 

[T. Valko]

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

 

[Guest]

thanks T. Valko, much appreciated for your assistance

will try out the syntax

and to community as well, thanks !

 

[RichardSchollar]

Hi

You can use WEEKDAY to determine what day of the week a date
represents - so to avoid Sat/Sun you could use the following check
(returns True if not Sat/Sun, False otherwise):

=WEEKDAY(A1,2)<6

Hope this helps!

Richard

 

[Guest]

yes RichardSchollar, it does help alot thanks for the assistance rendered

to community as well, much appreciated

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

thanks T. Valko, much appreciated for your assistance

will try out the syntax

and to community as well, thanks !