Formula to include next months first business day

Terrif

Good morning, I am looking for a formula to calculate the total of how many times the helper sheet has data for a given month but to include the first business day of the next month since the report is filled out for the previous days numbers.

For example I want to calculate how many times an over/under amount was added to this helper sheet by created date and to also include Nov 1 create date since technically the numbers for Nov 1 was for Oct 31 sales.

The formula I currently have is :

=COUNTIFS([Over/Under Amount]:[Over/Under Amount], "<>", YEAR([Created Date]:[Created Date]), YEAR(TODAY()), MONTH([Created Date]:[Created Date]), 10, DAY([Created Date]:[Created Date]), 1, WEEKDAY([Created Date]:[Created Date]), "<=5")

But I keep getting #Invalid Data Type

Paul Newcome

I would suggest using a helper column with a formula to output the previous working day and then just leverage this one in any date based calcs.

=WORKDAY(DATEONLY([Created Date]@row), -1)