Attendance Point Tracker with point drop off

Hi after two days of searching the internet I decided to create a post, hoping someone can help me. I am creating an attendance point tracker where every 6 month/180 days the point drop off and are no longer calculated. I tried a conditional format but that only highlights when the points should drop off. It does not actually stop them from being included in the total. I then tried combining my conditional format formula with my countif formula (AH7) but that is not working either. Any help is greatly appreciated. Thank you.

Another option

Formula:

Please Login or Register  to view this content.