Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Date comparison

Topic Labels: Formulas
Solved
Jump to Solution
641 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Solution

Accepted Solutions

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

See Solution in Thread

1 Reply 1

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