Help to sort VBA data based on submission date

Hi!

I have the following data: ID, order #, submission date, price, submitted by, case. 

I want to get all orders that are submitted today (column c), then check their case (column h), then count orders, which have their case set to "1".