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"
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"
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