Entering today’s date in Excel

It works in lots of places

You can use a keyboard shortcut to enter today’s date in a cell, but you can also use it in lots of other places in Excel.

The keyboard shortcut to enter today’s date is Ctrl + ; (that’s the semi-colon).

The date is entered as if you keyed it in. It is not a formula.

If you want a formula that always displays the current day’s date use

=TODAY()

You can use the keyboard shortcut

  • when a cell is selected to enter today’s date in that cell
  • when you are typing in a cell and want to add today’s date to the text or a formula
  • when you are in a text box or other graphic and want to insert today’s date
  • when you are in a note or a comment, to enter today’s date
  • when you are in a dialog and need today’s date

It works pretty much everywhere in Excel.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.