I have two tables:
- On Call Roster
I want to use the values from holidays in some formulas in On Call Roster. The Holidays are defined by Name and Date (no date range). The aim is to get them summed up so that I can use them as a parameter in the following function: WORKDAY(startDate, numDays, [holidays]).
I am mostly stuck in how I reference the fields from the other table, without linking them.