Forum Discussion

Bryan Rainey's avatar
Bryan Rainey
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) ...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 01, 2017

Hi Bryan,

 

Please try

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

Resources