Glad to hear it!

--JP

On Sep 18, 11:35*am, KalliKay
wrote:
Simple fix....I got it. *Thanks for your assistance.

KK



"KalliKay" wrote:
If there is no date in W5 and Q5 does not equal 100%, the value placed in the
date field comes up with 1/0/1900. *How do I get this to place nothing in the
field then? *
Thanks.

"JP" wrote:

Try this:

=IF(AND(Q5=100%,W5=""),"Action Required",W5)

--JP