Automatic Date and Time in Excel

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.

About spreadsheetexpertblog

Working as a computer professional since 1983, on projects varying in size from one person to multi-million pounds. Working on Excel projects since the mid 1990s.
This entry was posted in Uncategorized and tagged , , . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s