Hi,

Please clarify.

Your header says the criteria should check a cell for TEXT, your details says the check should be for a DATE.