VbA code to find previous date

[aman1234]

Hi All

I want VbA code to find a date 1 less than todays date taking into account weekends/Bank Holidays.

Any help will be much appreciated.
Thanks

[aman1234]

I have set up the table for bank holidays. please see attached.

[aman1234]

I am using the following code:

Please Login or Register  to view this content.

But I also need to check bank holidays and Weekends too in the code. Any help will be much appreciated.
Thanks