View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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