| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| validate a date range | Excel Discussion (Misc queries) | |||
| Hide Alternate Labels on Date Axis | Charts and Charting in Excel | |||
| Get Day from Date to Validate | Excel Discussion (Misc queries) | |||
| Validate date within range prior to calculation | Excel Discussion (Misc queries) | |||
| How can i use a command button to validate date and time | Excel Discussion (Misc queries) | |||
Linear Mode
