COUNTIF Issues

They do not. But this is my fault.

I created the example on the 22nd and the data reflected that. I posted here on the 23rd so of course the TODAY formula changed everything

Attached is the correct information. (I replaced the original file I added.) There are 9 possible outcomes per butler as shown in the desired outcome table.

The formulas you send, thank you kindly, are counting the 'Arrival's & 'Exits' as 'In-House' thus coming back with 12.

Apologies for my oversight.