Change status based on a date

Hey guys, I would like to set a status based on a date column. For example; “set the status to “Week One”, when date is current week”. Is this possible or would a formula column be better suited to create the automation off of?

This should work for you! A series of these may work for rolling cases.