Nov 12 2020 07:02 AM
Nov 12 2020 07:20 AM
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.
Nov 12 2020 07:44 AM
With holidays and vacations in a list on the sheet:
I'm not sure about the difference between WORKDAY and WORKDAY.INTL.
WORKDAY might pick up "ordinary" bank-holidays in a US system. It does not with my regional settings.
Nov 12 2020 07:53 AMSolution
Nov 12 2020 11:07 AM
@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.