Hey All,
Hoping someone can help me out i am sure it is a simple solution but i am coming up blank.
I am creating a shift rota for a manufacturing facility 3 shifts Dayshift, BackShift and Nightshift.
I have a holiday report on one tab with the employee name in colum B:B and the 1st date of the holiday in column D:D and the last day of the holiday in Column E:E
On the Rota tab i have 3 shifts Sunday to Friday for each machine. What i am trying to do is once the employee name has been put into that shift for that day for a helper cell to do a countifs or something to search that date monday, tue etc. and see if they are due to be off on holiday. from there i can format it to go red if they are off using the helper cells, That is what i am thinking.
If you think there is a better way i am happy to go that route too
I have included snagits of the tabs below
Holiday Tab.gif
Rota Tab.gif
Any and all help would be greatly appreciated
Bookmarks