trebor1956
Board Regular
- Joined
- Jul 2, 2015
- Messages
- 100
- Office Version
- 2013
- Platform
- Windows
Hi I am using excel 2013. I have individual sheets for each team member that use 'networkdays' to calculate holiday used between a start and end date. I would like to put a letter 'R', 'A' or 'D' in columns in a summary sheet depending who has booked holiday.
I can't attach the workbook I am trying on so I have copied the relevant sheets below. I just can't seem to get my head round it so have cleared all my attempts so far. Any help would be greatly received.
Worksheet for Rob
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>
I can't attach the workbook I am trying on so I have copied the relevant sheets below. I just can't seem to get my head round it so have cleared all my attempts so far. Any help would be greatly received.
Worksheet for Rob
<colgroup><col span="2"><col><col><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>