|
validate alternate day date
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 |
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 |
validate alternate day date
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 |
validate alternate day date
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 |
validate alternate day date
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 |
validate alternate day date
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 On 13 Mar, 01:21, tikchye_oldLearner57 wrote: 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 |
validate alternate day date
yes RichardSchollar, it does help alot :) thanks for the assistance rendered
to community as well, much appreciated -- oldLearner57 "RichardSchollar" wrote: 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 On 13 Mar, 01:21, tikchye_oldLearner57 wrote: 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 |
validate alternate day date
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 |
| All times are GMT +1. The time now is 09:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com