I have two dates : Release date and action plan complete date. Both coming from the same table
I need to find the number of Working days between these two dates ,based on a calendar table , but this table is in another universe...the only way I can pull the table is by using a separate query.
Release date : 3/21/2014
Action plan date : 3/28/2014
No. Of business days : 6 days
Calendar table in another universe has all dates from 2007 to 2018 and a flag for holidays. The holiday flag 1 if its a holiday and 0 if it is a working day.
Please help to figure out how to calculate the number of working days between the above two dates based on the calendar table.