Formulas Challenge for 365

Thank you for reading this post!   I propose a formulas challenge (The shorter the better).  Attached is a workbook in need of two formulas.  I have solutions for each (Formula 1 is 66 characters, ...