Try this syntax

=MAX(IF((Community=Z1)*(Date>=Z2)*(Date<=Z3),Usage))

confirmed with CTRL+SHIFT+ENTER

where Z1, Z2 and Z3 contain a specific community name, start date and end date respectively