Forum Discussion
Try to set a date on my cell and an data validation error appears
I've been trying to re-make a very simple Task Tracker that I had made on Google Sheets to Excel, and most fuctions work except the one to insert the Due Date of the Assigment. It opens the calendar ...
This is a data validation rule for dates, but it's tricky since it will only work if you enter the date in certain formats, not all valid date formats. What did you enter that triggered the error message?
Hi, HansVogelaar ! Thanks for replying. I've tried entering the date in any way I know. With /, -, ., with spaces only, with the calendar that pops up, with letters, and everything leads me to the same error. I've even tried to change the format of the cells to "general", instead of "date", and the error persists.
I'd remove the data validation rule from the date column.
