Hello!
I am trying to calculate how much annual leave "Bob" had during the week ending 6/1/2017. This sheet hasn't pasted so well, sorry. The "a" on the attendance sheet sits in A7. But I need to know for each entire week, and this formula needs to work for all employees. I'm stuck!! Thank you for any help
<colgroup><col span="2"><col span="31"></colgroup><tbody>
</tbody>
<colgroup><col span="2"><col span="31"></colgroup><tbody>
</tbody>
I am trying to calculate how much annual leave "Bob" had during the week ending 6/1/2017. This sheet hasn't pasted so well, sorry. The "a" on the attendance sheet sits in A7. But I need to know for each entire week, and this formula needs to work for all employees. I'm stuck!! Thank you for any help
January 2017 | ||||||||||||||||||||||||||||||||
Present | A | Annual Leave | S | Sick Leave | U | Unpaid Leave | W | Weekend worked | ||||||||||||||||||||||||
Sun 01 | Mon 02 | Tue 03 | Wed 04 | Thu 05 | Fri 06 | Sat 07 | Sun 08 | Mon 09 | Tue 10 | Wed 11 | Thu 12 | Fri 13 | Sat 14 | Sun 15 | Mon 16 | Tue 17 | Wed 18 | Thu 19 | Fri 20 | Sat 21 | Sun 22 | Mon 23 | Tue 24 | Wed 25 | Thu 26 | Fri 27 | Sat 28 | Sun 29 | Mon 30 | Tue 31 | ||
Bob | s | s | A | p | p | |||||||||||||||||||||||||||
Jim | ||||||||||||||||||||||||||||||||
Frank | ||||||||||||||||||||||||||||||||
Arthur | ||||||||||||||||||||||||||||||||
Mary | ||||||||||||||||||||||||||||||||
Doris | ||||||||||||||||||||||||||||||||
Betty | ||||||||||||||||||||||||||||||||
Nancy | ||||||||||||||||||||||||||||||||
Charles | ||||||||||||||||||||||||||||||||
Annie |
<colgroup><col span="2"><col span="31"></colgroup><tbody>
</tbody>
<colgroup><col span="2"><col span="31"></colgroup><tbody>
</tbody>