Forum Discussion
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...
=IF(E9=EOMONTH(E9,-1)+1,TEXT(E9,"dd/mm/yyyy"),EOMONTH(E9,0)+1)