Try the Today() function - don't need to enter anything between brackets.

"Tpeyton77" wrote:

How can I enter a formula in a cell so that when I click on that cell it will
show today's date or the current date?