Hi there
I have a roster which has name of staff in column A.
In column D I have name of teams each staff belongs to.
Row 2 has the month and the year. eg Jan-15 all the way to Dec-16
Row 3 has the days in each cell. eg Mon, Tue, Wed, Thu, Fri, Sat, Sun.
Row 4 has the days of each corresponding month in each cell. eg: 1, 31
In row 313 shows me the Total Available to Work fr each date.
In a new sheet I want to be able to put in a desired date and selecting team and be able to get the result of total available to work in.
appreciate ay help.
attached the file sample
I have a roster which has name of staff in column A.
In column D I have name of teams each staff belongs to.
Row 2 has the month and the year. eg Jan-15 all the way to Dec-16
Row 3 has the days in each cell. eg Mon, Tue, Wed, Thu, Fri, Sat, Sun.
Row 4 has the days of each corresponding month in each cell. eg: 1, 31
In row 313 shows me the Total Available to Work fr each date.
In a new sheet I want to be able to put in a desired date and selecting team and be able to get the result of total available to work in.
appreciate ay help.
attached the file sample