I have a spreadsheet which is a holiday tracker.
we have NWD (Non Working Days), i.e. Every Friday is a NWD.

In the spreadsheet there is a list of Holidays which can be added and these apply to everyone. They are in a table listed under the Name Manager as Holidays.

for the Workday.INTL formula this works. It also works across a number of other formulas within the "Calc" Sheet.

What I have done is produce a "NWD" Sheet. It is intended that all staff will fill in their NWD's on here.

I need the formulas which have the 'Holidays' table in them to also include all days specific to the name identified in column D of cal.

so for example, cell N11 of sheet Calc has the formula:

=IFERROR(IF(OR(COUNTIF(Holidays,L11)>0,INDEX(Dashboard!$I$20:$I$26,MATCH(M11,Dashboard!$H$20:$H$26,0))="No"),"h",""),"")

Where it picks up holidays I need it to also pick up all dates against the person in cell D11 from the NWD table.

Hope this explains.

It wont let me upload the file but I have attached a screenshot for examples.

Screenshot 2023-12-12 154758.png
Screenshot 2023-12-12 154942.png
Screenshot 2023-12-12 155018.png