loop function to get free dates

Dear, follow the information as requested:

Above is the table with the auditors column, with each code in each row representing an auditor. The other column is the auditor's state of residence, which must be the same for both auditors in the pair and the same for the supplier.

Above is the supplier table. The supplier is represented by a code and has a state that must be the same as the state of the pair of auditors.

The table above contains data corresponding to dates from today to one year in the future, that is, today plus
364 days. Each auditor will be entered in a column, and their respective audits will be filled in with the code
of the supplier whose audit is scheduled.

Above is the table with the auditors and their respective municipal holidays, that is, it may be a municipal
holiday for a certain auditor and not for another.

Above is a sample of the results. In other words, the results table allows you to see which suppliers have scheduled audits, which auditors will conduct the audit, and the auditors' free dates for scheduling future audits.

The goal is to ensure that no supplier in the supplier list is left without a scheduled audit.

Thank you in advance for your help and attention.