Countif or Sumproduct

[Wilson]

Can someone help write a formula that will provide a count total for a range
of cells where the value (xx/xx/xx) is within plus or minus 5 business days
of a date in the corresponding cell of another column.

 

[ND Pard]

Try this:

First put a formula in each row to determine if the date is within plus or
minus 5 business days. Something similar to, assuming your date value
(xx/xx/xx) is in cell Column C2 and your corresponding cell is in H8:

=If(ABS(C2-H8)<=5,1,0)

Then do a sum of this new column to arrive at the count of the number of
rows that meet the criteria.

I hope this helped.

Good Luck.

 

[Pete_UK]

Give us a few cell and sheet references to work with - it's easier to
visualise.

Pete