You can prevent such situations by using a date picker. Method 1: Change the Cell Format The fastest way to add a date picker in Google Sheets is to change the cell format itself.