There are several ways to insert time and date in excel. You can insert a static date in your worksheet.
A static date in a worksheet doesn’t change when the worksheet is recalculated or opened at some other time.
It is also possible to insert a date in an excel worksheet, using a function that recalculates and updates whenever the worksheet is opened.
Another way is to insert date and time in excel, using a function, this also recalculates whenever the worksheet is opened.
Let’s take a look at the three different ways to insert time and date in excel.
Have you learnt about Excel cell references?
MANUALLY INSERTING DATE
All you have to do:
- Select a cell you wish to insert the date.
- Press the shortcut key below on your keyboard.
- Control (Ctrl)+semicolon key (;): insert current date.
The current date on your computer will be inserted in your worksheet as shown in this video below.
Major setback is that, the date won’t update or recalculates automatically, which means if you open the worksheet tomorrow, next month, next year, it will still have that date.
What if you want your date to change and update, whenever you open your worksheet from where you saved it last, so, it reads the current date.
To do that, you need a function called TODAY.
The syntax comes with an open and closed parenthesis with nothing in it.
The today functions read the date that’s in your computer clock, and it will automatically update whenever you re-open or recalculates your worksheet.
Force the whole worksheet to recalculates by pressing the shortcut key.
- Press “F9” key: force worksheet to recalculates.
Now function provide the date and the current time on your computer and insert in your worksheet
The function automatically updates and recalculates exactly like today function
Syntax comes with an open and closed parenthesis with nothing in it.
Download file for practice: Date and Time
Here is a video of how the function work.
Now that you know a few different ways to insert time and date in excel, educate someone today by sharing. Thanks, sharing is caring.