How to enter today's date in excel?

2 answer(s)
Answer # 1 #

Use the formula =TODAY(). It automatically displays the current date and updates daily.

[7 Month]
Answer # 2 #

Press Ctrl + ; (semicolon) to insert the current date as static value that won’t change.

[7 Month]