The =NOW() function is a quick shortcut to enter the current date & time to your Sheet. It's dynamic and will update every time you open your Sheet. If you'd like to make the date & time 'stick' after using this formula, select the cell and use Edit->Copy followed by Edit->Paste Special > Paste value only. 

More about =NOW() here:  #TuesdayTip  
Animated Photo
Shared publiclyView activity