Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

# Calculating the most recent date out of three date fields

Topic Labels: Formulas
Solved
597 5
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hi!

In my base I have 3 fields where various dates are entered, based on when a client was contacted. Basically a first, second, and third touch point in communication.

I have a fourth field that currently pulls the most recent date based on what’s entered in the other 3 columns. If only the first contact field has a date, then the most recent outreach is that date. If the second contact point has a date, then it assumes that date is most recent. Same with the third contact date… if anything is entered into that field, it assumes it’s the most recent.

My issue is that sometimes, 6 months to a year down the road, the contact points may start over, and that first date may become the most recent date. (But because there are still dates entered into the other two fields, the 4th field assumes they are still the most recent, when they aren’t)

Is there a way for it to calculate within the system which of the three dates is actually the most recent date?

I hope that makes sense!

1 Solution

Accepted Solutions
16 - Uranus
5 Replies 5
16 - Uranus
5 - Automation Enthusiast

That is amazing and worked great! One follow up question - is there a way to remove the timestamp and only have the date?

16 - Uranus

That formula outputs a date, meaning you can edit the field’s format options to not include the time.

5 - Automation Enthusiast

Ah, got it! Didn’t even think about that.

Thank you so much for your help!!

5 - Automation Enthusiast

@Jayme_Richardson, the following formula will work. Please note, “First”, “Second”, “Third” are the field names. Also, it assumes that you have a process where dates are entered into the fields chronologically.

IF(Third, Third, IF(Second, Second, First))