Difference between Now() and Today() functions in Excel
The
Today() function returns only the current date, without the time.
The
Now() function returns both the current date and time.
Workaround to insert current date as a static value
Instead of using the Now() or Today() function, you can use the keyboard shortcut
"Ctrl + ;" to insert the current date in a cell.
Here are the steps to insert the current date using the keyboard shortcut:
- Select the cell where you want to insert the date.
- Press "Ctrl + ;" on your keyboard.
- The current date will be inserted in the selected cell as a static value.