|If you want to put today’s date into your spreadsheet, then use =today().
But remember this is dynamic, which means it will change. Thus it’s not much use for dating a document, because tomorrow’s another day!
To get the current date and time, use =now().
This like =today() is dynamic, but even more so. Because it includes the time it will update almost every time a value in the spreadsheet is changed.
If you wish to insert today’s date as text, then type Ctrl+; and for the time type Ctrl+:
These can be combined in a single cell.
However, if you want Excel to automatically insert the date and/or time as text, then you’ll have to use VBA.
Join 2 other subscribers