Saturday, Sunday or Holiday BY-PASS

I have a patient visitation spreadsheet. Normally, when a patient is seen a 30 day followup will be posted.
I want to post a visit date and the next cell will display the scheduled 30 day date. No check for Saturday, Sunday or Holidays.
I have all holidays listed in another worksheet.
My current formula is: =IF(NOT(ISERROR(DATEVALUE(TEXT(D4,"mm/dd/yyyy")))),D4+30,"")
What I what is to select the very next date after Saturday, Sunday or Holiday.
Any assistance work be greatly appreciated.
Thank you,
Glenn