Buzz
In this article, I'll guide you through two methods that can help you input dates swiftly in Excel 2016.
GUIDE TO FAST DATE INPUT IN EXCEL
Instead of inputting the complete date, use these two methods to enter concise dates. For example, if you want to input 20/11 or 20-11, Excel will automatically add the current year, resulting in 20/11/2018 or 20-11-2018.
Method 1: Choose the Short Date format. Excel adopts the date format of your Windows. Follow these steps:
Step 1: Assuming you've selected the Windows date format as dd/mm/yyyy (day/month/year). Choose the cell to input, as described in the image below:
Step 2: Go to the Home tab and click on the 'Down Arrow' as shown in the image below:
Step 3: A Menu appears, and you choose Short Date.
Step 4: After selecting, quickly input dates into Excel. You can input like: 20/11 or 20-11.
After inputting, press Enter to see the result:
Method 2: Utilize custom format - Custom Format to format dates. Suppose you need to input dates with the format: dd-mm-yyyy, follow these steps:
Step 1: Choose the cell that needs quick date formatting.
Step 2: Go to the Home tab and click on the 'Arrow' as described in the image below:
Step 3: In the Format Cells interface, Number tab, select Custom:
Step 4: In the Type section, type dd-mm-yyyy and click OK to complete.
When you input the date 20/11 or 20-11, the result will resemble Step 4 in Method 1 as instructed above.
Here, I've just guided you through two customization methods for you to swiftly input dates in Excel. These methods are quite straightforward, so I believe you can easily execute them. Additionally, there are many useful date functions in Excel. Wishing you success!
