reports45.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Employee	Hiring Date	Termination Date	Billing period		Amount of payments for the last 3 months			Amount of payments included in calculation	Number of working days according to schedule	Number of days worked by employee	Average Salary
2	Employee	Hiring Date	Termination Date	start	end	Salary	Bonuses	Surcharge	Amount of payments included in calculation	Number of working days according to schedule	Number of days worked by employee	Average Salary
3	Charlotte	2/7/2019	2/20/2023	11/1/2022	1/31/2023	$ 9 000	$ 500		$ 9 500	#VALUE!	48	#VALUE!
4	Evelyn	1/12/2020	4/3/2023	1/1/2023	3/31/2023	$ 9 000		$ 150	$ 9 150	#VALUE!	56	#VALUE!
5	Jacob	8/1/2020	8/29/2023	5/1/2023	7/31/2023	$ 3 000			$ 3 000	#VALUE!	21	#VALUE!
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100