IF AND FORMULA WHEN ONE CELL IS BLANK

Fialko66

I am struggling to get what I thought should be a simple IF/AND formula to work, can anyone help please?

I have a column called Date Due and One called Date Submitted and all i want is a formula to look at both and if the Due Date is <= Today AND the Date Submitted cell is blank to return text to say OVERDUE.

I have some IF/AND statements in other sheet i set up and tried following them but never used a blank cell and just keep getting errors messages

This is what i have tried, amongst other things = IF(AND([DATE DUE]@row<=TODAY(),[DATE SUBMITTED]@row ISBLANK,"OVERDUE",""))

Thank you

Ipshita

Hi @Fialko66, you need to start your formula with the =IF(ISBLANK( to check for the blank cell

Try and let me know if that works!

Cheers!

Ipshita