Hi all

I'm sure this is straight forward but my limited brain power is....well....limited. How can I get Excel to calculate the maximum number of consecutive days per employee, i.e., Person 2 = '2' as there are 4 periods when the consecutive days do not go past 2 days.
A B C
Name Actual Start Date Actual End Date
Person 1 01/08/2019 01/08/2019
Person 2 01/08/2019 01/08/2019
Person 1 01/08/2019 01/08/2019
Person 1 01/08/2019 01/08/2019
Person 2 05/08/2019 05/08/2019
Person 2 07/08/2019 07/08/2019
Person 1 08/08/2019 08/08/2019
Person 2 08/08/2019 08/08/2019
Person 1 08/08/2019 08/08/2019
Person 1 08/08/2019 08/08/2019
Person 2 14/08/2019 14/08/2019
Person 1 15/08/2019 15/08/2019
Person 2 15/08/2019 15/08/2019
Person 2 19/08/2019 19/08/2019
Person 2 21/08/2019 21/08/2019
Person 1 22/08/2019 22/08/2019
Person 2 22/08/2019 22/08/2019
Person 1 22/08/2019 22/08/2019
Person 1 22/08/2019 22/08/2019
Person 2 28/08/2019 28/08/2019
Person 1 29/08/2019 29/08/2019
Person 2 29/08/2019 29/08/2019
Person 1 29/08/2019 29/08/2019
Person 1 29/08/2019 29/08/2019
Person 1 29/08/2019 29/08/2019
etc...