Hello,

I have a column with a text value in it, for example Z01. I need to
determine if that value should be in the cell only if a date appears in
another cell. The Z01 column is Q and the date that is formatted as
m/dd/yyyy is in column M.

Thanks!