SELECT * FROM dbo.NonMemberProvider WHERE officecalled IS NULL AND DATEDIFF(hour, UPDATEDate, GETDATE()) > 72 AND ( SELECT * FROM F_TABLE_DATE(UPDATEDate, GETDATE()) WHERE d.[DAY_OF_WEEK] BETWEEN 2 AND 6 )

Not unless you have a specific holiday or set of holidays in mind. Certain holidays fall on different dates each year (for example, first Monday of the month), whereas others are always on the same day, in which case:

SELECT *
FROM dbo.NonMemberProvider
WHERE officecalled IS NULL
AND DATEDIFF(hour, UPDATEDate, GETDATE()) > 72
AND DATEPART( WEEKDAY, UPDATEDate ) between 2 and 6 AND NOT ( DATEPART(month,UPDATEDate)=12 and DATEPART(day,UPDATEDate)=25 ) -- excludes December 25

SELECT *
FROM dbo.NonMemberProvider T
WHERE officecalled IS NULL
AND DATEDIFF(hour, UPDATEDate, GETDATE()) > 72
AND DATEPART( WEEKDAY, UPDATEDate ) between 2 and 6 and UPDATEDate not in ( select holdate from HolidayTable )