So I have the formula figured out for between dates to calculate what I have on hand C11 being the date, however whats stumping me is to count if no date is in the BK column???
=COUNTIFS('10-16'!$BK:$BK,">="&C11,'10-16'!$S:$S,"<="&C11,'10-16'!$D:$D,"Cat")
<tbody>
</tbody>
=COUNTIFS('10-16'!$BK:$BK,">="&C11,'10-16'!$S:$S,"<="&C11,'10-16'!$D:$D,"Cat")
<tbody>
</tbody>