Today’s Date in a Cell

Need to quickly put today’s date in a cell? There are two ways depending on the desired result.

1) =TODAY() will update the date in the cell every time the file is opened. If today is March 12, 2014, that is what the cell will read. However, when the file is opened again in three days, it will read “March 15, 2014” because the function will update the contents of the cell.

2) Ctrl + ; will insert today’s date as text into a cell. This is helpful for documents that track when things were completed, as the date will not change when the document is re-opened at a later time.

What are your thoughts?