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.

​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.  Read More

​