A date is a number, so...
=ISNUMBER(B1)
But make sure this condition is above the red one.
For your next thread, check out all the options for sub forums and pick the one that relates to the question asked.
This sub forum is, "Introduce yourself"
Edit: Thread moved to Worksheet Functions sub-forum.
Bookmarks