Moving Cells as a condition if today's date does not equal the condition stated

[Bryan Rainey]

Trying to use an if function to put in data in a wordcount spreadsheet.

This is the formula I am using.

Trying to find a solution to the formula.

  =if(A3=4/1/2017, B3=K18,Sheet'Apr 17!'B4)

Thanks

[#2]

Hi Bryan,

Please try

 =IF(A3=DATEVALUE("4/1/2017"),
     B3=K18,
     Sheet'Apr 17!'B4)