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:

1. Select the cell where you want to insert the date.
2. Press "Ctrl + ;" on your keyboard.
3. The current date will be inserted in the selected cell as a static value.