Instructions on how to insert the current date in Excel
For those who often have to deal with large volumes of calculations, Microsoft Excel is a useful support tool to help you complete all tasks. Based on functions and formulas, users can calculate the data stored on the spreadsheet. When data changes, formulas will automatically update changes and produce new results, saving users a lot of effort.
TODAY () function is 1 of 7 date functions in Excel. This function is useful when we want to display the current date on the file, the function returns the current date at the time the user opens the file. For those who have to deal with time management spreadsheets, especially inserting the current time, they need to use TODAY () function. However, in addition to using this formula function, we can also use another way to add the current date and time to Excel.
Method 1: Use TODAY () function:
The use of the TODAY () formula function is widely used by many users. This function will update the time on the computer to Excel and can change the date when you turn off or reopen the file.
Step 1:
You perform data entry, spreadsheet spreadsheet in Excel. In the cell to get the current date value, we enter the statement = TODAY () .
Step 2:
We press Enter and the result returned is the current date.
Step 3:
To enter the current date for other data cell areas, you need to hold and drag the current date box first to the data area to insert the date.
In addition to the formula function insert the current date TODAY () above, you can also refer to other important Excel formula functions in the lesson. These are the most basic functions in Excel that you need to understand.
Method 2: Use Ctrl + ";":
When you are too familiar with using calculator functions, you will often forget the shortcut keys that have similar functions but perform faster again. This will enter a static date, meaning no change over time on the computer.
Step 1:
We place the mouse cursor in the cell where we need to enter the current date value .
Then press Ctrl +; and will show the current date in the spreadsheet.
Step 2:
Finally, you can perform the maintenance and drag the first date to copy to the data box below.
Using this shortcut brings many useful uses to users, making operations faster and more time-saving. In addition to Ctr + key combination; To insert the current date, you can also refer to many other shortcuts when working with the post data spreadsheet. Summary of expensive shortcuts in Excel.
So, with 2 simple and easy ways to insert the current date in the Excel spreadsheet we summed up above, hope you can handle the amount of work quickly and efficiently.
Instructions for inserting dates into Excel
Refer to the following articles:
- You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!
- 10 ways to recover corrupted Excel files
- How to reopen Word, Excel or PowerPoint files when closed but not saved yet?
I wish you all success!
You should read it
- Instructions on how to fix reverse dates in Excel
- Summary of trigonometric functions in Excel
- How to format dates in Excel
- How to fix the SUM function doesn't add up in Excel
- Complete financial functions in Excel you should know
- How to add computers to Excel
- How to use functions to identify and calculate date information in Excel
- Date time functions in Excel
- How to display 0 in front of a number in Excel
- MS Excel - Lesson 5: Excel formulas and functions
- Excel date function - Usage and examples
- Instructions for inserting a PDF file into Excel spreadsheet
Maybe you are interested
How to Fix Clipboard History Error in Windows 11 Latest Update
4 Ways to update Win 11 Driver, quick update tips
Microsoft makes major improvements to Windows Update, updates will be installed much faster
WinRAR 6.10 beta update fixes Windows 11 context menu bug
Windows updates constantly, why?
How to update graphics drivers in Windows 10 and 11