You can not check the value in a cell and then poplulate that cell itself so
you need to enter this in R (or whatever is available)
=IF(M1<"",Q1,"")

This will check for blank cell M1 and populate with value in Q1 only if it
is NOT blank.

"Daren" wrote:

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!