Hi Nelson
_1)
Quote Originally Posted by nelsondavid View Post
.....25 days ABSENT ,i.e, Absent 4 days plus one holiday (4 days) -29,31,9,19 and 30 (the employee did not come on 29 and 31 so 30 holiday marked as absent).......
This makes no sense ??? I have no idea what you are saying ???


_2)
I think you have wrong data again ! ! !

Your after “File 4 After.xlsx”
Row\Col
B
C
34
TOTAL NO. OF DAYS -----> 25
Worksheet: 121

Your Before File “File 3 Before.xlsx”
Using Excel 2007 32 bit
Row\Col
E
F
G
1
21.Dec.16
7:00
1
18:00
2
22.Dec.16
7:00
2
18:00
3
23.Dec.16
7:00
3
15:00
4
24.Dec.16
7:00
4
18:00
5
25.Dec.16
7:00
5
18:00
6
26.Dec.16
7:00
6
18:00
7
27.Dec.16
7:00
7
17:00
8
28.Dec.16
7:00
8
18:00
9
29.Dec.16
10
30.Dec.16
11
31.Dec.16
12
1.Jan.17
7:00
9
18:00
13
2.Jan.17
7:00
10
18:00
14
3.Jan.17
7:00
11
18:00
15
4.Jan.17
7:00
12
18:00
16
5.Jan.17
7:00
13
18:00
17
6.Jan.17
18
7.Jan.17
7:00
14
18:00
19
8.Jan.17
7:00
15
18:00
20
9.Jan.17
21
10.Jan.17
7:00
16
18:00
22
11.Jan.17
7:00
17
18:00
23
12.Jan.17
7:00
18
18:00
24
13.Jan.17
7:00
19
18:00
25
14.Jan.17
7:30
20
17:30
26
15.Jan.17
7:30
21
17:30
27
16.Jan.17
7:30
22
17:30
28
17.Jan.17
7:30
23
17:30
29
18.Jan.17
7:00
24
18:00
30
19.Jan.17
31
20.Jan.17
Worksheet: 121


_........................


_2)
The test data that you have chosen does not test this scenario “...holiday is deducted if the person does not come the day before and after the holiday...

Possibly you mean something like this ???
29.Dec.16
ABSENT
30.Dec.16
7:00
18:00
11:00
9:00
2:00
31.Dec.16
ABSENT
Worksheet: 121
????

_................................

Try again !!!

Quote Originally Posted by DocAElstein View Post
.....
You must make sure that your test data in Before and After illustrates all possible scenarios( and that it is correct ! )
....