I am trying to set up a formula that will count the instances of specific
dates. Example: Only count the number of times that a cell in Column B
(B4=1) and a corresponding cell in Column C (C4=2) meet the required
parameters.

I have been trying to use the COUNTIF function but can not get it to work
with the AND function since the AND function does not seem to work well with
a range of data.

Any help would be appreciated.