Check for holidays

Hi Experts

I'm writing a program that checks to see if our company is delivery goods on time. The problem is that we do not deliver goods on public holidays or Sundays.

I first hardcoded the holidays, but the department that uses the worksheet have to wait for us to change it each year. I think it would be a better idea to have a separate sheet with these dates in the workbook so they can change the holidyas themselves.

This is a portion of my previous code:

Please Login or Register  to view this content.

How do I go about getting the code to check the shipment dates against the dates in the sheet?

Thanx for all your help

Kind Regards

Hi All

Solved my problem thanx

Kind Regards