In almost any blank mobile, variety ‘=ISTEXT(’ and choose any on the list of cells of your date column. Shut the bracket ‘)’ and press the Return critical. The ISTEXT() function is used to find out if a certain mobile incorporates a text value or not. With this dialog box, https://www.customguide.com/google-sheets/how-to-lock-cells-in-google-sheets