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 and the rest of the Assigments that I imported seem to be working well, but when I try to add a new date, this error appears. I don't understand why, since the Data Validation formulas are only supposed to work on the Course and Type columns. Please help me, I just wanted to be a responsible student.
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.
