2. Make the IF function to recognize a date in your logical test as a date, you have to wrap it in the DATEVALUE function, like this DATEVALUE("01/21/2021"). The IF formula should evaluate the dates...

Extracted text: 2. Make the IF function to recognize a date in your logical test as a date, you have to wrap it in the DATEVALUE function, like this DATEVALUE("01/21/2021"). The IF formula should evaluate the dates in column C and returns "Completed" if a game was played before Nov-11. Otherwise, the formula returns "Coming soon". Game Date Status 8-Oct Completed 10-Dec Coming soon 27-Nov Coming soon 10-Nov Completed 17-Nov Completed Game 1 Game 2 Game 3 Game 4 Game 5 Game 6 6-Dec Coming soon 3-Nov Completed 22-Dec Coming soon 27-Nov Coming soon Game 7 Game 8 Game 9