Search results for query: *

I would need to count the days as one set of days taken off and exclude the holiday. See examples below. Example1: Friday holiday before taken 9/2 = 1 9/5 = 0 9/6 = 2 9/7 = 3 9/8 = 4 9/9 = 5 Example2: no previous day taken 9/5 = 0 9/6 = 1 9/7 = 2 9/8 = 3 9/9 = 4 no additional days taken...

Thanks after a little tweaking that worked. The other issue I have is to account for holidays and not include in the count of days taken. For example if someone took off 9/2, 9/6, 9/7, 9/8, 9/9. Since 9/5 is a holiday they were really off 5 work days.

Hello, I am needing to loop through records of employees with time take off dates and determine how many days off have been taken off in a row. For example, jDoe has dates 09/01/2016, 09/02/2016, 09/03/2016, 09/05/2016. I need to know that 3 days were taken off in a row. Below is the code and...