Formula based on date and status columns
I currently have the below formula in a column titled "Health' to create a symbol if the request was created more than 21 days ago (red) or less than 21 days ago (green). However, I want this formula to also include the status column that would include "received" or "open" and exclude the "submitted" status. How do I do this?
Current formula without status column being included:
=IF([Request Creation Date]@row < TODAY(-21), "Red", "Green"