Column A has a long list of dates. Some are consecutive days, some are not.
What I want is for column B to show is if that date is part of a consecutive sequence, the number of days that are in that sequence.
For example:
A B
13/02/2023 1
15/02/2023 2
16/02/2023 2
18/02/2023 3
19/02/2023 3
20/02/2023 3
22/02/2023 1
24/02/2023 2
25/02/2023 2
Bookmarks