If and function help needed

[ll1100000]

Here is my worksheet, and I want have a formula like below:

If [receiving date] is not empty and [Arriving date] is empty, then [Arriving date] = [receiving date]

I don't see the IF AND function in the formula tool, so how to solve this problem...

Thank you.

UPC	Arriving date	Receiving Date
66092121030		12/28/2017
66092121146		1/5/2018
66092121191		1/5/2018
66092121245	12/1/2017
66092121290	12/1/2017
66092121344	12/1/2017
6609212134	12/1/2017	12/1/2017

[DataBlender · Accepted solution]

Hi @ll1100000

I think your issue may be the last part of your IF function.

Try bringing in a formula tool and setting the field to be 'arriving date'. That way, any output will be placed into this column. Our expression is then:

IF !IsEmpty([Receiving Date]) AND IsEmpty([Arriving date])
THEN [Receiving Date]
ELSE [Arriving date]
ENDIF