Ok so I think I solved this myself taking on everything I've learned since coming here.
I added sheet "Holidays Taken" to calculated number of days holiday input on "Planner" sheet which is recorded as initials of name represented by helper column H on sheet "Employees".
Formula on "Holiday Overview" for each employee and month corresponding is multiplied by helper column F sheet "Employees" which is then basically days holiday*hours worked.
Everything works as I intended but my question is, have I gone about things the long way? Did I need all the helper columns/pages I have setup or was there a simpler way?
Either way it works so I have accomplished something
Thanks
Bookmarks