Formula for labeling events as Upcoming / Current / Closed

[Lauren_Studebak]

Hi there,

I’m new to Airtable formulas, and I’m having a difficult time constructing a nested if formula that automates labeling events as open, upcoming, and ended. All items have an Opening and Closing date entered in their respective fields, and I’m hoping to have them but I can’t seem to compare them to today’s date accurately - does anyone have any suggestions?

[Elias_Gomez_Sai]

Check this:

Adding a SOON or UPCOMING State to completed due dates Ask the community

So I found this helpful article https://support.airtable.com/hc/en-us/articles/221104988-Conditional-formulas-with-emoji and used the IF({Completed} = 1, “:white_check_mark:Done​:white_check_mark:”,IF(IS_BEFORE({Due date}, TODAY()), “:alarm_clock:OVERDUE​:alarm_clock:”,“:running_man:In-progress​:running_man:”)) AND IF(Completed = 1, “”,IF(IS_BEFORE({Due date}, TODAY()), “:alarm_clock:OVERDUE​:alarm_clock:”,"")) Formulas. I am wondering how I could add a date range and have a DUE SOON stage…