Hello I have a spreadsheet showing many dates approx 20,000 that show number of tests taken.
I would like to find out the number of tests taken in column A (dates) match that of all the dates in column B (dates) or were held 1 day later. Example Below dates would show as 2 dates matching, is there a piece of analysis to do this? any help would be appreciated, thank you
<colgroup><col><col></colgroup><tbody>
</tbody>
I would like to find out the number of tests taken in column A (dates) match that of all the dates in column B (dates) or were held 1 day later. Example Below dates would show as 2 dates matching, is there a piece of analysis to do this? any help would be appreciated, thank you
01/04/2018 | 01/04/2018 |
02/04/2018 | 03/04/2018 |
01/05/2018 | 06/04/2018 |
01/06/2018 | 23/07/2018 |
<colgroup><col><col></colgroup><tbody>
</tbody>