I have the following working formula
Located in K2 =IF(INDEX(Details!B18:B81,MATCH(C2,C2,0))<>C2,S30,"0")
So I want it to only use the number in S30 if the date in C2 is not in a range of dates on the Details Page within B18:B81
Now I need to use this formula on the below cells, however, there is an additional check that needs to be done
This working formula is
Located in K3 =IF(AND(C3 < TODAY()+1, J2<>""), K2+S$30, )
So I am wanting the above formula to do what it does if the date in C3 is not in the range on the Details Page within B18:B81 (The date range is either Sunday's or days closed)
If C3 is in the range I want it to add Zero instead of the number from S30
The attached image gives you the cells referenced and for this formula, S30 is equal to 2