Formula for a status column based on a date range

Hello. I have a worksheet with a start date column and an end date column. I’d like to write a formula to set the status based on the date range. For example:
If start date greater than today, set status to “Future”
else if start is less than or equal to today and end is greater than or equal to today, set status to “Active”
else if end date is less than today, set status to “Archive”

I can’t quite figure out the syntax for this. Any suggestions? Thanks!

Hi @Erica_Warhaftig ,

An if-else-if formula that you can consider is:

Also sharing sample workbook for quick reference: Reference Implementation

1 Like