How can I build this formula in quickbase. Field D and E are arrival and departure dates and I need to filter records within those dates

I can make this work in excel but don't see the "and" option in QB. =IF(AND(E7<=(D7-1),E7>=C7),"InHouse","Not InHouse") My goal is to have a report that only includes in house guests