Countif or Sumproduct
 

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.

Countif or Sumproduct
 

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.
"Wilson" wrote:

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.

Countif or Sumproduct
 

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

Pete

On May 15, 3:39*pm, Wilson wrote:
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.