Hi All,
Would an expert on this Please.
On Cell P3 i wanted to display a text like this "6 Days" or "7 Days" else "5 Days"
I have a schedule that looks Like this: (The name of the employee would be on Cell B2)
Cell H2 would be Sunday (This would be the Current Week)
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
In the table below SUN would be Cell AH2 so on and so forth (This would be employees previous week schedule)
<colgroup><col span="6"><col></colgroup><tbody>
</tbody>
Would an expert on this Please.
On Cell P3 i wanted to display a text like this "6 Days" or "7 Days" else "5 Days"
I have a schedule that looks Like this: (The name of the employee would be on Cell B2)
Cell H2 would be Sunday (This would be the Current Week)
SUN | MON | TUE | WED | THU | FRI | SAT |
09:00-18:00 | 09:00-18:00 | 09:00-18:00 | 09:00-18:00 | OFF | OFF | 09:00-18:00 |
09:00-18:00 | 09:00-18:00 | 09:00-18:00 | 09:00-18:00 | OFF | OFF | 09:00-18:00 |
08:00-17:00 | 08:00-17:00 | 08:00-17:00 | 08:00-17:00 | OFF | OFF | 08:00-17:00 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
In the table below SUN would be Cell AH2 so on and so forth (This would be employees previous week schedule)
SUN | MON | TUE | WED | THU | FRI | SAT |
11:00-20:00 | 11:00-20:00 | 11:00-20:00 | 11:00-20:00 | OFF | OFF | 11:00-20:00 |
11:00-20:00 | 11:00-20:00 | 11:00-20:00 | 11:00-20:00 | OFF | OFF | 11:00-20:00 |
10:00-19:00 | 10:00-19:00 | 10:00-19:00 | 10:00-19:00 | OFF | OFF | 10:00-19:00 |
<colgroup><col span="6"><col></colgroup><tbody>
</tbody>