Hi, welcome to the forum

I too, am not really understanding what you want

You have a date in A1
You enter a value in A2
Then you want A2 to show something else?

You can either have data in a cell (value or text) or a formula, you cannot have both

perhaps try explaining what you want again?