excel 2003

[Kratt]

is there a keyboard shortcut for entering today's date into a cell?
I cannot find any. but its a common task.. pirate2

[Krehator]

CTRL + ; Current Date
CTRL + SHIFT + ; Current Time.

[AnyDemo]

Hello,

If you use it very often, you may write a simple macro:

Sub date_now()
ActiveCell.Value = DateValue(Now)
End Sub

Then assign the above macro to a new menu item or sub-menu in the menu bar. Or assign the above macro to a new tool icon in the tool bar.

Then you can simply click the menu or tool icon when you need to input the to-day's date to the active cell.