# Comparing tables with dates

• Re: Comparing tables with dates

Since you didn't say what the formula is trying to do, take a look at this.
If that's not it, please explain further what you're trying to do?

## Files

Best Regards,
Luke M
=======
"A little knowledge is a dangerous thing."

• Re: Comparing tables with dates

Closest date after, before, or either?

Best Regards,
Luke M
=======
"A little knowledge is a dangerous thing."

• Re: Comparing tables with dates

Quote from Luke M;770254

Closest date after, before, or either?

before

• Re: Comparing tables with dates

Formula in D3 then is:

IF(COUNTIFS(\$B\$11:\$B\$16,B3,\$C\$11:\$C\$16,"<="&C3)=0,"No earlier dates for this index",
INDEX(\$D\$11:\$D\$16,SUMPRODUCT((\$B\$11:\$B\$16=B3)*(\$C\$11:\$C\$16<=C3)*(ROW(\$B\$11:\$B\$16)))-ROW(\$B\$11)+1)))

Best Regards,
Luke M
=======
"A little knowledge is a dangerous thing."

• Re: Comparing tables with dates

Perfect, thanks man!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!