Need help with British Gas/Business Gas/Scottish Gas as they can pay three different ways
1. if D2="British Gas/Business Gas/Scottish Gas",C2="British Gas/Business Gas/Scottish Gas" then minus 180days from G2 AND USE EOMONTH
2. if D2="British Gas/Business Gas/Scottish Gas",C2="does not =British Gas/Business Gas/Scottish Gas" look at date in B2 ,IF DATE IS >01.02.2018 THEN USE THIS CODE WHICH IS THE MAIN CODE '=IF(E2="Pending Reg",EOMONTH(G2,1)+0*(DAY( ETC
Solved by B. H. in 16 mins