Hi, I have two columns, one with a date and time (column A) and one with a status (column B).
I want a third column(Column C) to say if the date and time in column A is less than today's date and the status in column B is not equal to 'COMPLETED' then move the date to today's date at 07:00:00...