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
