You want to insert a static day/time stamp in Google Sheets.
After you've installed the NowStamp bookmarklet, click to edit any cell and then click on the bookmarklet. Bam!
Thanks to Ben Johnson for providing the JS.
To add this functionality to your own bookmarks bar, simply click+hold & then drag the button below to your bookmarks bar!
Stuck? Here's how: