Count IF based on date

Hello All - I have a scenario where I do a count IF based  on below sample data  table 1. Count IFS - Priority (P1,P2..) based on Open date & Closed date with situation = Issues ( should exclude act...