Quite often, Excel formats the newly inserted date according to your Windows default date settings, but sometimes it may leave it exactly as you typed.The most obvious visual indication that Excel has recognized the date you've entered is its right-alignment in a cell as opposed to left-aligned text values.If this does not help, please check other Excel date format troubleshooting tips.In Microsoft Excel, you can input the current date and time either as a static or dynamic value. Timestamping is entering a "static date" that won't change with the course of time or when the spreadsheet is recalculated.If you are using a 64-bit version of Excel 2016, Excel 2013, Microsoft's Date Picker control won't do.In this case, consider using one of the third-party calendars, for example our own one :) For more options, please see third-party drop-down calendars for Excel. I am hopeful these date entering techniques, shortcuts, functions and Excel auto date features have proved useful to you.
To fix this, double-click the right border of the column to auto fit the date, or drag the right border to set the desired column width.
If you are using a 32-bit version of Excel, you can use Microsoft's Date Picker control.
For the detailed instructions, please see How to insert calendar in Excel (Date Picker control).
Or, perhaps you want to insert a date in Excel that will update automatically and always display the current date and time?
Or, maybe you want to auto fill weekdays or input random dates in your worksheet?