Forum Discussion

Copper Contributor

Apr 01, 2017

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

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

MVP

Hi Bryan,

Please try

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