Broken Count formula

Hi there, please tsee the attached the formula in D4 and D9 have stopped working and i cant for the life of me work out how to fix them.

They should return the number of unique accurances of a number (account number in this case) that appear in a column based on date perameters

Can somebidy please help.

Thanks