lynxbci
Board Regular
 Joined
 Sep 22, 2004
 Messages
 201
 Office Version

 365
 Platform

 Windows
 MacOS
Hi,
Consider this table of employees off sick. Person A has had several periods of time off, and they happen to be all consecutive, totalling 158 days.
I am struggling for a formula/Method to return the number of consecutive days Person A has had off??
Consider this table of employees off sick. Person A has had several periods of time off, and they happen to be all consecutive, totalling 158 days.
I am struggling for a formula/Method to return the number of consecutive days Person A has had off??
Person  Off Date  Back Date  Days Off  Consecutive days off 
A  12/05/2020  31/05/2020  20  158 
B  18/05/2020  19/05/2020  2  2 
C  21/05/2020  23/05/2020  3  3 
A  01/06/2020  30/06/2020  30  158 
B  03/06/2020  19/06/2020  17  17 
A  01/07/2020  31/07/2020  31  158 
A  01/08/2020  31/08/2020  31  158 
C  13/08/2020  13/08/2020  1  1 
A  01/09/2020  30/09/2020  30  158 
C  12/09/2020  14/09/2020  3  3 
A  01/10/2020  16/10/2020  16  158 