hi everyone, is there a formula that can compare 2 dates (a due date and the completion date of a project) and fill in if it was finished on time, early or late?
Solved
Date comparison
+2Best answer by kuovonne
Welcome to the Airtable community!
You can use a variety of date/time comparison formula functions. They are documented in the formula field reference.
Here is one possibility to get you started:
IF( IS_AFTER({due date}, {completion date}), "early",
IF( IS_BEFORE({due date}, {completion date}), "late",
IF( IS_SAME({due date}, {completion date}), "on time"
)))
+29Welcome to the Airtable community!
You can use a variety of date/time comparison formula functions. They are documented in the formula field reference.
Here is one possibility to get you started:
IF( IS_AFTER({due date}, {completion date}), "early",
IF( IS_BEFORE({due date}, {completion date}), "late",
IF( IS_SAME({due date}, {completion date}), "on time"
)))
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.