Hi,
Need help of a multi-condition date validation rule.
Please see attached.
Many TX
Multi-condition date validation rule
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Multi-condition date validation rule
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78393
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multi-condition date validation rule
Create a validation rule of type Custom, with the following formula:
=AND(B2>=A2,B2<=WORKDAY(A2,3))
=AND(B2>=A2,B2<=WORKDAY(A2,3))
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Multi-condition date validation rule
Much appreciated.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.