Help

Date comparison

Topic Labels: Formulas
Solved
Jump to Solution
1616 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ana_velingard
5 - Automation Enthusiast
5 - Automation Enthusiast

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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