IF formula to compare a date with current date and return result

Question

I'm trying to find a formula that will let me check a cell's value against the current date to see if it's greater than or equal to today's date and provide a written response like "late." Return another word or nothing if the field is empty.

There must be a way to read the data from the source cell since I've tried transferring the outcome from the source cell (O10) into another cell (Y10) and using an if statement, but this seems unnecessarily difficult. Look below. Additionally, it returns late if the cell is empty:

=IF(O10>Y10,"OVERDUE","NOT DUE")

Answer 1

You can enter the following formula in the cell where you want to see the Overdue or Not due result:

=IF(ISBLANK(O10),"",IF(O10<TODAY(),"Overdue","Not due"))