# Re: IF formula assistance using dates

Solved
287 1
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hello! I'm creating an Airtable base to manage book club meetings. I have a column for the meeting dates (DD/MM/YYYY) which take place once per month. I'd like to have a "Reading Status" column that uses a formula to create the following labels:

• "All Done" for meetings where the date has already passed
• "Up Next" for the upcoming meeting
• "Not Yet Read" for future meetings that are not the next closest meeting

I am new to formulas and struggling with how to set this up. Any help would be much appreciated. Thank you!

1 Solution

Accepted Solutions
18 - Pluto

Finding out which record is "Up Next" isn't possible with just a formula field I'm afraid.  To get the upcoming meeting you're going to need to create a linked field to another table and do calculations to figure out which meeting is the upcoming one

"All Done" and "Not Yet Read" are easily done with formulas though!

``````IF(
IS_BEFORE(
DATETIME_PARSE(
{Date in Text},
"DD/MM/YYYY"
),
TODAY()
),
"All Done",
)``````

(If your date is in a Date type field you can just remove the "DATETIME_PARSE" bit)

2 Replies 2
18 - Pluto

Finding out which record is "Up Next" isn't possible with just a formula field I'm afraid.  To get the upcoming meeting you're going to need to create a linked field to another table and do calculations to figure out which meeting is the upcoming one

"All Done" and "Not Yet Read" are easily done with formulas though!

``````IF(
IS_BEFORE(
DATETIME_PARSE(
{Date in Text},
"DD/MM/YYYY"
),
TODAY()
),
"All Done",