validate alternate day date
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
|