Forum Discussion
please help
- 1. Are you absolutely sure your computers language setting is US/English? In some other languages we use ; instead off, as separator
2. In some cases WEEKday starts from 0 instead of 1. Try the Weekday(C3) outside of "data validation"
safoine Perhaps your local settings require a semi-colon to separate arguments in formulae.
Try =AND(WEEKDAY(A2)<>1;WEEKDAY(A2)<>7)
Oooops: didn't see the previous post until I posted mine.
Hello Riny_van_Eekelen
thank you a lot it's working
do you have any formula to make the date will not take place during vacations, public holidays and weekends please ?
i create two liste public holidays and vacations.
safoine Perhaps best demonstrated in the attached file. See if you can "translate" the data validation to your own workbook.
hello Riny_van_Eekelen
I appreciate your help so much
Can I make the error message depend on data is entered?For example if the day is weekend the error message tell me it's Sunday or Saturday or if its holiday the error message tells that's a holiday.
safoine In the Input message you could stat that the date should not be a weekend or a holiday. Then in the error message you can write a more friendly message explaining what input is accepted, but I don't think it's possible to create an error message depending on the particular reason for the error (i.e. Saturday, Sunday or Holiday). But perhaps I'm wrong. Don't know.