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
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 |