Good Day!
Please help me on how to create an excel formula that will check if an employee will render 7 day straight working days in 2 consecutive weeks. Please see sample below.
The week starts on a Monday shift
The condition holds TRUE if the schedule of an employee will have more than 6 straight work days between week 1 and week 2.
[TABLE="width: 960"]
<colgroup><col span="7"><col><col span="7"></colgroup><tbody>[TR]
[TD]13-Nov[/TD]
[TD]14-Nov[/TD]
[TD]15-Nov[/TD]
[TD]16-Nov[/TD]
[TD]17-Nov[/TD]
[TD]18-Nov[/TD]
[TD]19-Nov[/TD]
[TD] [/TD]
[TD]20-Nov[/TD]
[TD]21-Nov[/TD]
[TD]22-Nov[/TD]
[TD]23-Nov[/TD]
[TD]24-Nov[/TD]
[TD]25-Nov[/TD]
[TD]26-Nov[/TD]
[/TR]
[TR]
[TD]mon[/TD]
[TD]tue[/TD]
[TD]wed[/TD]
[TD]thu[/TD]
[TD]fri[/TD]
[TD]sat[/TD]
[TD]sun[/TD]
[TD] [/TD]
[TD]mon[/TD]
[TD]tue[/TD]
[TD]wed[/TD]
[TD]thu[/TD]
[TD]fri[/TD]
[TD]sat[/TD]
[TD]sun[/TD]
[/TR]
[TR]
[TD]off[/TD]
[TD]off[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD] [/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]off[/TD]
[TD]off[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance guys!
Please help me on how to create an excel formula that will check if an employee will render 7 day straight working days in 2 consecutive weeks. Please see sample below.
The week starts on a Monday shift
The condition holds TRUE if the schedule of an employee will have more than 6 straight work days between week 1 and week 2.
[TABLE="width: 960"]
<colgroup><col span="7"><col><col span="7"></colgroup><tbody>[TR]
[TD]13-Nov[/TD]
[TD]14-Nov[/TD]
[TD]15-Nov[/TD]
[TD]16-Nov[/TD]
[TD]17-Nov[/TD]
[TD]18-Nov[/TD]
[TD]19-Nov[/TD]
[TD] [/TD]
[TD]20-Nov[/TD]
[TD]21-Nov[/TD]
[TD]22-Nov[/TD]
[TD]23-Nov[/TD]
[TD]24-Nov[/TD]
[TD]25-Nov[/TD]
[TD]26-Nov[/TD]
[/TR]
[TR]
[TD]mon[/TD]
[TD]tue[/TD]
[TD]wed[/TD]
[TD]thu[/TD]
[TD]fri[/TD]
[TD]sat[/TD]
[TD]sun[/TD]
[TD] [/TD]
[TD]mon[/TD]
[TD]tue[/TD]
[TD]wed[/TD]
[TD]thu[/TD]
[TD]fri[/TD]
[TD]sat[/TD]
[TD]sun[/TD]
[/TR]
[TR]
[TD]off[/TD]
[TD]off[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD] [/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]1000-0700[/TD]
[TD]off[/TD]
[TD]off[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance guys!