Dates

[Weldon Riker]

if the date in C1 is greater than 03/06/2018 put the value in B1 in C1

 

[Weldon Riker]

if the date in C1 is greater than 03/06/2018 put the value in B1 in C1

Whoops! put the value in C1 in D1

 

[AlanSidman]

In D1 =if(C1>3/6/2018,C1,""). Make sure to format D1 as a date

 

[Nikunj Rastogi]

Hello Dear,
Put this formula into cell D1 and then you will get the correct answer.
=if(c1>Datevalue("03/06/2018"),c1,"")

 

[Weldon Riker]

Hello Dear,
Put this formula into cell D1 and then you will get the correct answer.
=if(c1>Datevalue("03/06/2018"),c1,"")

Thanks!! that did work (with a couple of different cell references) I am truly grateful