So cell J18 also has an error but because there is something in L5 (even though it shows nothing). If you click in L5 and hit delete (even though there appears to be nothing in there) then cell J18 will also give a error result.
So under Date 2 (i.e. cell J14) put this formula and fill down: =IF(L1="","",IF(L1<=$C$6,L1,"FALSE"))
And under User 2 (i.e. cell N14) put this formula and fill down: =IF(L1="","",IF(L1<=$C$6,M1,"FALSE"))
TestBook problem.xlsx
Cheers
Bookmarks