ToText(ToWeekdayN([Holiday]))
For the Third Work Day I used:
var text tableID = "tid";
var text query = "{hoFID.GTE." & [Test Date] & "}";
var TextList dates = GetFieldValues(GetRecords($query, $tableID), hoFID);
var bool isHoliday = Contains($dates, ToText(FirstDayOfMonth([Test Date]))) or
Contains($dates, ToText(WeekdayAdd(ToWeekdayN(FirstDayOfMonth([Test Date])), 1))) or
Contains($dates, ToText(WeekdayAdd(ToWeekdayN(FirstDayOfMonth([Test Date])), 1)));
var number dayOffset = If($isHoliday, 3, 2);
WeekdayAdd(ToWeekdayN(FirstDayOfMonth([Test Date])), $dayOffset)
where tid is the table ID for the Holidays table and hoFID is the field IF for Holiday Observed.
The formula query will return a list of holidays that are on or after the Test Date field. The isHoliday variable will check to see if the holiday observed date is in the first three working days of the month. The dayOffset will return 3 if isHoliday is true and 2 if it is false.
I hope this helps. Let me know if you have any questions.
------------------------------
Paul Peterson
------------------------------
var number holidays = If(Contains($dates, ToText(FirstDayOfMonth([Test Date]))), 1) +
If(Contains($dates, ToText(WeekdayAdd(ToWeekdayN(FirstDayOfMonth([Test Date])), 1))), 1) +
If(Contains($dates, ToText(WeekdayAdd(ToWeekdayN(FirstDayOfMonth([Test Date])), 2))), 1) +
If(Contains($dates, ToText(WeekdayAdd(ToWeekdayN(FirstDayOfMonth([Test Date])), 2))) >0 and
Contains($dates, ToText(WeekdayAdd(ToWeekdayN(FirstDayOfMonth([Test Date])), 3))), 1);
var number dayOffset = 2 + $holidays;