Count cells between occurrences of specific values

[Lingim]

Hell All,
I am doing some work on time sheets in excel and am having trouble coming up with a formula (or VBA) to determine the number of days between leave days; and the number of working days in a row.
in the below pic days off are "L", working days are of a variety of values. Each row is a fortnight but would like formula to be able to continue through each row downward.
hope someone can assist in pointing me in the right direction.
Cheers

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

D

D

D

D

D

D

L

L

L

D

D

D

L

L

D2

D2

D2

D2

D2

D2

D2

D2

L

L

L

L

L

D

D

D

L

L

L

L

L

D

D

D

D

D

D

D

 

[kweaver]

Welcome. In your example, what answer(s) are you looking for?

 

[Lingim]

Hi Kweaver,
I didn't explain my self very well, sorry.
Am looking for a result such as workdays=5, leave=3,workdays=3,leave=2,workdays=8,leave=5, workdays=3,leave =5, workdays=7, etc..
in the example above the roster has 3 lines, but will be working on rosters of 20 lines plus.
the format of the result is not critical, i just need to be able to analyse the roster pattern to ensure compliance with business rules.
Result could be a VBA solution that i can run, no need for real time. Result could even be a separate .csv file. I just can't seem to come up with a solution that works.

Thanks for your help.