Data Validation - multiple criteria

[apurk45]

In Data Validation Custom - I'm trying to use the formula that would allow users to enter "X" or week date based on cell D3 Monday date (i.e. 3/07/2022).
In other words.... user should be able to enter only date from week of 3/7/22 : 3/7/22, 3/8/22, 3/9/22, 3/10/22, 3/11/22, 3/12/22, 3/13/22. 3/6/22 or 3/14/22 should not be allowed

=OR(D8="X",D8=WEEKDAY(D3,2))

This formula allows me to enter "X", but rejects any date I try to enter.
Any help modifying this formula will be greatly appreciated.


Regards,
John

 

[jtakw]

Hi,

Use this formula for you DV:

=OR(D8="X",IF(N(D8),WEEKNUM(D8,2)=WEEKNUM(D3,2),0))

 

[apurk45]

Works perfectly...
Thank you very much.

 

[jtakw]

You're welcome.