I want to calculate the number of working days for each individual employee.
I have the Table Emp
EMPID STARTDATE ENDDATE
01 05/15/2010 12/31/9999
02 01/02/2010 05/15/2010
02 04/20/2010 04/30/2011
02 01/02/2010 05/15/2012
I understand we can use networkdays to calculate the number of Working Days by excluding the Saturday,Sunday and Holidays. But it will give me 180 days. However i want the number of working days per Emp on monthwise
