Multi-condition date validation rule

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Multi-condition date validation rule

Post by Rudi »

Hi,

Need help of a multi-condition date validation rule.
Please see attached.

Date Validation.xlsx

Many TX
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.
Top
User avatar
HansV
Administrator
Posts: 78369
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multi-condition date validation rule

Post by HansV »

Create a validation rule of type Custom, with the following formula:

=AND(B2>=A2,B2<=WORKDAY(A2,3))
Best wishes,
Hans
Top
User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Multi-condition date validation rule

Post by Rudi »

Much appreciated. :thumbup:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.
Top

Return to “Excel and other spreadsheet applications”