Hey Guys,
I'm trying to create a weekly summary of items due that week from a table that I've created but I cant seem to get the formula to work, even when running it as an array. I feel like I'm missing something but I can't figure it out. My first instinct is to maybe use a nested If function but I can't visualize how it would end without being incredibly lengthy and time consuming. Additionally, I would need to modify the formula every time a new line is added to the table, which doesn't make a lot of sense from a practical standpoint.

This is the formula I tried, but it only returned a zero value when I know the correct return value should be 3.
=COUNTIF(Table2[ARR DATE],WEEKDAY(TODAY(),2)<5)