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: