To ensure that a date column is used correctly, you can effectively insert a calendar in Excel, using an Excel date picker. ... Then, click the cell where you want to add the date picker.