Use this 2 Formula for the data validation

=IF(OR(ISDATE(J14), J14="RECEIVED"), TRUE, FALSE)

OR

=OR(ISDATE(J14),ISTEXT(J14))

Sample Output

Result on first formula

Result on second formula

Note: Adjust your data range based on your needs and also edit the given formula

Reference

• ISDATE
• ISTEXT