What is the best way to count a set of data

Hello guys!   I encounter the following problem. I need to count number of occurrence of OFF, MC, AL and etc day for James, Jane and John for the set of date range. (as per sample data)   Date...