Forum Discussion
Solved
please help
I want the date will not take place during vacations, public holidays and weekends.
- 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"
Hello safoine,
That's interesting. I have entered the same formula and am not receiving an error. Perhaps you could open a new worksheet and enter the formula again?
Note that this data validation allows only dates that are not Saturday's and Sunday's. It does not account for vacations and holidays.
I tried again and it doesn't work. yes I know its for Saturday and Sunday that's why I tried an easy formula.
- 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"Hello MindreVetande
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 lists public holidays and vacations