Date comparison

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?

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"
)))
1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.