Thanks Danny! When I tried it still no luck but when I put in a date I was
golden!
=IF('Full Log'!L501/01/1900,"X","")
You're the best!

Thanks again.

Kim

"Danny" wrote:

Kim,

Please try:

=IF('Full Log'!L5"","x","")

"kim" wrote:

IF['Full Log'!L50]THEN[value=x]

The above is what I tried and obviously failed.
Thanks!

"kim" wrote:

In the first worksheet I have a column entitled Ship Date. In another
worksheet I want only for the column to identify if a ship date is present
with an x. How can I do that? Thank you for your assistance!
Kim