Methods to create an Excel Date Time stamp in your spreadsheets depending on whether you want it to update itself or not.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
Excel Date Time Stamp
It is sometimes necessary in Excel to capture the date and the time but you don’t want Excel to update itself, you just want to put in the current date or time. Effectivily creating an Excel date time stamp. Instead of looking at the Calendar or at your watch, there is a nice shortcut you can use.
So if you want the date, what we can do is we hold the control key down and push the semi-colon – and you will see it gives you today’s date. If you want the time – you hold the control – shift and the semi-colon – it will tell you the current time. Notice that both of these are basically typed in so they are date-time-stamp. If tomorrow we opened up – it would still have these dates and times.
If you want to have this spreadsheet change the date depending on what day it is – there are two or three functions you can use. So one function under the date and time section is a function called “today” – as you can see it is just today, open bracket, close bracket, when I push OK it gives me today’s date –but because it is a formula – “tomorrow” will give me tomorrow’s date.
A similar type of function called “now” – what this one does – same syntax gives us the date and the time. And what you’ll see is next time we do an operation it will update this time depending on whether it has ticked over to the next minute – so let’s see ok so there you can see time has moved on to the next time.
It is important to realize that Excel is getting this data from your machine so if your machine’s date, or time is incorrect – it will not give you the correct information over here.