IF function, dates, and late/on time

Kate Allison

Hi! I'm trying to figure out how to write a formula that will show whether a task was completed on time or after its due date. Here's what I tried, but it didn't work:

=IF([Completion Date]17<=[Due Date]17, Yes, [No])

I'm trying to say if the completion date is on or before the due date, populate the cell with Yes (on time). If the completion date is after the due date, populate the cell with No (late).

Any ideas on how I can fix this? I keep getting the error #UNPARSABLE.

Thank you for any help!

Kate

Paul Newcome

You just need quotes around your desired text outputs.

=IF([Completion Date]17<=[Due Date]17, "Yes", "[No]")

Kate Allison

Thank you!!

Paul Newcome

Happy to help! 👍️