Hi,

Is it possible to use the NOW function within an IF statement? What I'm trying to do is to insert a timestamp into a cell adjacent to the cell where a user will enter their name. So if I was to enter my name in cell A1, I would like the date and time that it was entered to be added to cell B1.

Is this possible, or should I be looking at this from a different perspective?

Many thanks for your time.

Richard Minns