Write excel formula to identify cases where $3$ of the following dates $($issue open date, issue assign date, Test date$)$ are before $11/1/2023$ and where there are no issue close dates after $7/1/23.$ Close date has blank values which is valid.