Hello,

Simple one I think but I just cant work it out

I have cell B4 as: =IF(X10=1,W18,IF(X10=0,"input"&" "&"name"&" "&"first",""))

X10is true/false for A4 which is NAME

W18 is =TODAY()

Once a name/text is entered into A4, I want B4 to turn to a value for saving purposes. So when the form is opened in future it shows the date it was created rather than todays date again.


can anyone help?



Thanks,

Michael