I want to have an "x" in rows where the criteria between two data fields is met (based on quarters). I'm using an IF/AND statement. =IF(AND(A2>9/30/22,B2<1/1/2023),"X"," ")

If Column A is >9/30/2022 and Column B is < 1/1/2023, an "x" should be added, if not the column is blank. This worked the first time I tried it, but I had an issue with the formula not correctly filling down the column; trying this again, the formula is correct in the rows, but "X's are not being populated. The format in A & B show they are set in a date format. Any ideas on what I'm doing wrong? I've attached an abbreviated spreadsheet showing what I have.

Attached Files

Assignment Test.xlsx (50.7 KB, 8 views)