Formula to find number sick leave instances and hours before and after stat holiday

I have a large data file for employee sick leave. Each line is an instance of sick leave. I would like to figure out how many instances and hours each employee has taken leave before or after a statutory holiday. I have been trying to figure this out for a couple of weeks – trying so many ways. I used list, dateif, networking days, histograms, but my skills are not that great. Any help would be appreciated.