Excel Formula for Today’s Date

Here is a quick formula that calculates the current date each time you open your spreadsheet.

  • Select a cell
  • Type the following formula: <Today()
  • Press Enter
  • Excel Today’s Date Formula
  • Now that cell will always display the current date and can be referenced in other formulas

NOTE: you can also use the Now command if you would like to include the time as well: <Now()

todays_time

 

 

 

For more excel techniques see our Excel Training Class.