G
Guest
Does anyone have any suggestions on how to find the number of matched date?
There are 2 lists of date under column A & B, and there is a given number 2
in cell C1. I would like to determine how many date under column A matched
with the date under column B within a range of error for 2 days, which is
given in cell C1.
For example,
In column A
5 Jan 2007, 8 Jan 2007, 13 Jan, 2007, 20 Jan, 2007, 26 Jan 2007, 29 Jan 2007
In column B
6 Jan 2007, 11 Jan 2007, 16 Jan, 2007, 25 Jan
The matched date under column A within a range of error for 2 days
5 Jan 2007, 8 Jan 2007, 13 Jan, 2007, 26 Jan 2007
There are 4 matched date, then return 4 in cell D1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
There are 2 lists of date under column A & B, and there is a given number 2
in cell C1. I would like to determine how many date under column A matched
with the date under column B within a range of error for 2 days, which is
given in cell C1.
For example,
In column A
5 Jan 2007, 8 Jan 2007, 13 Jan, 2007, 20 Jan, 2007, 26 Jan 2007, 29 Jan 2007
In column B
6 Jan 2007, 11 Jan 2007, 16 Jan, 2007, 25 Jan
The matched date under column A within a range of error for 2 days
5 Jan 2007, 8 Jan 2007, 13 Jan, 2007, 26 Jan 2007
There are 4 matched date, then return 4 in cell D1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric