How Do I get the Upcoming Date from a Date field

Hi guys,
I currently have an Events table that shows all my Events with their Name fields and Date Fields.
I need in my case to set status for each of the Event - DONE, UPCOMING, LATER. How best can I achieve this. Most of the formula’s I have tried are not giving me the required solutions.

Since you didn’t define what you consider “upcoming” vs “later”, here’s the general idea.

IF(
  {Date Field},
  IF(
    {Date Field} < TODAY(),
    "DONE",
    IF(
      DATETIME_DIFF({Date Field}, TODAY(), "days") < 8,
      "UPCOMING",
      "LATER"
    )
  ),
  "No Date"
)
1 Like

Thank you Kamille.

To explain better what I want to do,
Airtable 01
So above are the list of my date. I want to create a status field that knows when the nearest future date to the todays date is set to as Upcoming, while further future date is set to as later and then past dates set to as Done events.

As you can see the next event should be on the 21st of July 2022.
Grinding hard to get the right formula but is just not working out yet.

You can’t compare dates across rows that aren’t linked. If the 7/21 record is not linked to the 8/4 record in some way, there is no way for Airtable to compare those two dates with a formula to determine that 7/21 is the upcoming one.

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