Need Some Help Please-how To *include Weekends And Holidays With Previous Work Day

[fst]

arnelgp, thanks, i'll check it out today and get back to everyone.

 

[fst]

arenlcp in the query 'qry_saag99_step2, if I put the date #6/01/2020# (Monday), the query result shows all data for that date rather data from 5/29-5/31 (fri-sun)? however, I noticed if I put #5/29/20# in the step2 query it'll combine 5/29-5/31 which is the opposite of what I was looking for. it's close though and appreciate your help on this!

 

[arnelgp]

if today is monday, you Manually put in your query the date for Friday.
it's that simple.