You can also type “@today” in a cell to get a non-updating version. It would be cool if they added a @now as well.