| 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. |
Contact me now for
Excel Specialist Advice >>