HI, I need some help please. I have a list of dates in column A that are in ascending order, however sometimes are seperated by blank cells.
I need column B to count how many occurences of consectutive dates occur after the date in Column A. Can anyone please help me. Thanks
I need column B to count how many occurences of consectutive dates occur after the date in Column A. Can anyone please help me. Thanks
CURRENT DATE | Count No. of consectutive dates after current date in A |
01/08/20 | 2 |
05/08/20 | |
07/08/20 | 2 |
08/08/20 | 1 |
10/08/20 | 1 |
11/08/20 | 0 |