Conditional Formula: Project Status based on Date

Hi, I am interested in using a conditional formula to either automatically select from a single drop down or to use a phrase with emojis.

{Program Status}
In this field I want to indicate in one field if a program is:
In Progress
Complete
Future

{Program Start} and {Program End} or {Program Start and End}
I have a field for start date and a field for end date (or I can create one field and type a range)

I am looking for a formula that will automatically generate a {Program Status} based on today’s date. I would appreciate any help. Thank you!

Hi @Alix_Boyle - have a look at this post and answer, which is pretty much what you need, I think:

JB