Hi
I would like to have a static time and date stamp automatically enter into two adjacent cells after a person has entered their intials in a cell.

Using an an "if then else" where it checks to see if initials have been entered then using now() will not work as it is always up dates when the sheet is recalculated. I dont think you can use ctrl+; in an =if( condition,true,false) statement.
Any ideas.
Thanks