Date minus 1 & Date minus 2 excluding weekends and holidays

[smartbuyer]

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

[CJ_London]

look to the bottom of this thread for examples of how to do this

[ssanfu]

Welcome to the forum.

This was interesting and frustrating.

The function returns the proper dates for me, but I'm in the USA, using US date format (mm/dd/yyyy). You might have problems with the returned dates (it has happened to me before). I did set formatting for display purposes ....

[smartbuyer]

Thank you for this! it looks awesome and I got it to work on my RptDate database.

The issue I am having now is that I am using the tD-1 and tD-2 in Excel sheets and other databases. So I am now getting an error about the Workday function not being recognized? what can I do to resolve these?

[ssanfu]

Did you copy the Workday function module to Excel or to the other databases??