To determine the number of Fridays (or any other weekday) between two prompted dates
CASE WHEN NEXT_DAY(TO_DATE(:2, ‘YYYY-MM-DD’) -1,’FRIDAY’) <= TO_DATE(:2, ‘YYYY-MM-DD’)
THEN
((NEXT_DAY(TO_DATE(:2, ‘YYYY-MM-DD’) -1,’FRIDAY’) – NEXT_DAY(TO_DATE(:1, ‘YYYY-MM-DD’) -1,’FRIDAY’))/7) + 1
ELSE
(NEXT_DAY(TO_DATE(:2, ‘YYYY-MM-DD’) -1,’FRIDAY’) – NEXT_DAY(TO_DATE(:1, ‘YYYY-MM-DD’) -1,’FRIDAY’))/7
END
But from the below table it would be simpler
If you have PS_TL_DATES_TBL in your instance, you can effectively count(*) from PS_TL_DATES_TBL WHERE THE_DATE BETWEEN :1 AND :2 AND DAY_OF_WEEK = 5