I’m looking to query/calculate when a report is due.
I have two monthly reports, one due on the 5th business day and the second on the 15th business day of every month for the next 4 years.
One problem is that our office works a 9/80 schedule (9 hours a day with every other Friday off). So I made a table tblCalendarCodes and a tblDates.
I assigned every single day for the next four years with a connecting FK to tblCalendarCodes. I figured that would help me count R “regular days” but most sql and vba loops I’ve seen requires a startdate and enddate to calculate the dates. Anybody have any other functions or ideas? My tables are attached.