Hello - I have a table with Start_Date and End_Date fields. I will be calculating the difference between them but would like to know if any of the dates between them are a weekend and or a holiday.
Query1 tells me how many weekend days are between the Start_Date and End_Date which is 1 of the 2 things I need. How could I account for the holiday (if any)? In my query the dates 5/24/2022-5/31/2022 and 5/27/2022-5/31/2022 fall between a weekend and a holiday so I would like a 3 as a result (Sat. & Sun =2 + holiday 1).