Date minus 1 & Date minus 2 excluding weekends and holidays (1 Viewer)

[smartbuyer]

I have table name: tblHolidayDates which has dates of holidays within the year

I would like to get 1 row of query shows column: 'tD-1' which is (Today's Date minus 1) and column 'tD-2' which is (Today's Date minus 2) which excludes weekends and holidays(tblHolidayDates)

I have attached 3 scenarios and my expected tD-1 & tD-2 results.

Any assistance is greatly appreciated.

 

[Minty]

Have a read of this thread http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51941&highlight=dates and many others that should be listed at the bottom of this thread !