I have been trying to figure out how to get Date-1 and Date-2 excluding weekends and holidays.
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