Well after piecing together internet codes I think I've put together the below code. If anyone see's any issues with it please let me know but i'm still trying to incorporate it to use the Boolean YES/NO to determine if the first week of the month should be counted as week one or if the 4 weeks after the is 4 weeks should be counted.
![]()
=IF(INT((DAY(C6)-1)/7)+1=1,COUNTIFS(G:G,I12),"0")
Bookmarks