Complex IF Statement - Excel

I'm trying to build a calculator for my team to  calculate benefit insurance effective dates based on an employees hire date. The 2 options are "First of month after waiting pd." or "First of month c...