Auto update status of project based on dates

[SalmonTC]

So I have various dates and wanted to update the status based on these dates. The status that I use are: Coming Soon, Active, TOM, Under Contract, Closed, Cancelled and Expired. I want the status to change automatically once it gets to those dates or if a date gets input manually like TOM, Under Contract, Closed or Cancelled.

 Here's an image of what I was trying to do, but it didn't work and was getting errors 

Anyone know what I am missing or how I can fix this ?