Spreadsheet: 846677d1697806909-salary-increase-based-on-date-of-employment-percentage-calculation-using-date
Sheet: Sheet1

S/N | DOJ | GROSS
32 | 1989-04-12 00:00:00 | 35000
27 | 2017-01-02 00:00:00 | 38000
4 | 2017-01-24 00:00:00 | 55000
101 | 2017-02-09 00:00:00 | 40000
122 | 2017-04-06 00:00:00 | 50000
1 | 2017-05-01 00:00:00 | 55000
125 | 2017-06-06 00:00:00 | 50000
137 | 2017-06-06 00:00:00 | 50000
186 | 2017-06-06 00:00:00 | 50000
194 | 2017-06-06 00:00:00 | 50000
47 | 2017-07-17 00:00:00 | 50000
181 | 2017-09-02 00:00:00 | 50000
9 | 2017-09-10 00:00:00 | 55000
11 | 2017-09-10 00:00:00 | 55000
15 | 2017-09-10 00:00:00 | 55000
158 | 2017-09-18 00:00:00 | 50000
124 | 2017-09-22 00:00:00 | 50000
12 | 2017-09-26 00:00:00 | 55000
121 | 2017-09-26 00:00:00 | 50000
183 | 2017-09-27 00:00:00 | 50000
159 | 2017-09-28 00:00:00 | 50000
136 | 2017-09-30 00:00:00 | 50000
162 | 2017-10-03 00:00:00 | 50000
168 | 2017-10-03 00:00:00 | 50000
197 | 2017-10-04 00:00:00 | 50000
198 | 2017-10-04 00:00:00 | 50000
59 | 2017-11-11 00:00:00 | 45000
195 | 2017-11-14 00:00:00 | 50000
120 | 2017-11-23 00:00:00 | 50000
2 | 2018-02-01 00:00:00 | 55000
52 | 2018-04-12 00:00:00 | 55000
60 | 2018-04-23 00:00:00 | 45000
5 | 2018-05-02 00:00:00 | 55000
3 | 2018-06-22 00:00:00 | 55000
152 | 2018-07-12 00:00:00 | 45000
50 | 2018-07-20 00:00:00 | 40000
182 | 2018-10-10 00:00:00 | 50000
49 | 2019-01-22 00:00:00 | 50000
180 | 2019-02-12 00:00:00 | 50000
166 | 2019-03-03 00:00:00 | 50000
13 | 2019-03-29 00:00:00 | 55000
35 | 2019-04-01 00:00:00 | 45000
28 | 2019-04-04 00:00:00 | 35000
184 | 2019-07-07 00:00:00 | 50000
53 | 2019-09-10 00:00:00 | 55000
54 | 2019-10-29 00:00:00 | 50000
185 | 2019-11-11 00:00:00 | 50000
205 | 2020-01-10 00:00:00 | 55000
56 | 2020-01-20 00:00:00 | 100000
206 | 2020-02-27 00:00:00 | 55000
37 | 2020-03-12 00:00:00 | 50000
41 | 2020-03-12 00:00:00 | 90000
42 | 2020-03-12 00:00:00 | 45000
43 | 2020-03-12 00:00:00 | 45000
157 | 2020-04-01 00:00:00 | 50000
104 | 2020-05-01 00:00:00 | 50000
105 | 2020-05-01 00:00:00 | 50000
106 | 2020-05-01 00:00:00 | 50000
107 | 2020-05-01 00:00:00 | 50000
103 | 2020-09-01 00:00:00 | 50000
196 | 2020-11-11 00:00:00 | 50000
61 | 2020-11-16 00:00:00 | 45000
99 | 2020-11-20 00:00:00 | 50000
6 | 2020-12-16 00:00:00 | 55000
14 | 2020-12-16 00:00:00 | 55000
57 | 2021-02-08 00:00:00 | 65000
165 | 2021-03-04 00:00:00 | 50000
40 | 2021-04-13 00:00:00 | 45000
8 | 2021-04-28 00:00:00 | 55000
7 | 2021-05-15 00:00:00 | 55000
219 | 2021-06-24 00:00:00 | 40000
222 | 2021-06-24 00:00:00 | 40000
169 | 2021-07-06 00:00:00 | 50000
226 | 2021-08-15 00:00:00 | 45000
201 | 2021-08-17 00:00:00 | 55000
204 | 2021-09-15 00:00:00 | 30000
207 | 2021-10-01 00:00:00 | 55000
167 | 2021-11-03 00:00:00 | 50000
173 | 2021-11-16 00:00:00 | 50000
174 | 2021-11-16 00:00:00 | 50000
175 | 2021-11-16 00:00:00 | 50000
176 | 2021-11-16 00:00:00 | 50000
227 | 2021-11-16 00:00:00 | 45000
38 | 2021-11-18 00:00:00 | 50000
139 | 2021-11-24 00:00:00 | 50000
108 | 2021-11-26 00:00:00 | 30000
210 | 2021-12-26 00:00:00 | 40000
117 | 2022-01-05 00:00:00 | 40000
39 | 2022-01-11 00:00:00 | 50000
187 | 2022-01-12 00:00:00 | 50000
69 | 2022-02-04 00:00:00 | 45000
65 | 2022-04-01 00:00:00 | 45000
68 | 2022-04-01 00:00:00 | 45000
154 | 2022-04-01 00:00:00 | 45000
70 | 2022-04-08 00:00:00 | 45000
71 | 2022-04-08 00:00:00 | 45000
73 | 2022-04-08 00:00:00 | 45000
91 | 2022-04-08 00:00:00 | 50000
109 | 2022-04-08 00:00:00 | 40000
153 | 2022-04-10 00:00:00 | 45000
164 | 2022-04-11 00:00:00 | 50000
100 | 2022-05-01 00:00:00 | 30000
74 | 2022-06-02 00:00:00 | 45000
218 | 2022-06-20 00:00:00 | 40000
31 | 2022-07-01 00:00:00 | 35000
118 | 2022-07-01 00:00:00 | 40000
160 | 2022-07-11 00:00:00 | 50000
113 | 2022-07-18 00:00:00 | 30000
114 | 2022-07-18 00:00:00 | 30000
116 | 2022-07-18 00:00:00 | 40000
92 | 2022-07-25 00:00:00 | 50000
93 | 2022-07-25 00:00:00 | 50000
94 | 2022-07-25 00:00:00 | 50000
66 | 2022-08-02 00:00:00 | 45000
95 | 2022-08-15 00:00:00 | 50000
98 | 2022-08-15 00:00:00 | 50000
51 | 2022-08-19 00:00:00 | 50000
119 | 2022-08-19 00:00:00 | 40000
134 | 2022-08-29 00:00:00 | 50000
111 | 2022-09-01 00:00:00 | 30000
112 | 2022-09-01 00:00:00 | 30000
58 | 2022-09-07 00:00:00 | 55000
126 | 2022-09-23 00:00:00 | 50000
67 | 2022-10-03 00:00:00 | 45000
213 | 2022-10-07 00:00:00 | 40000
25 | 2022-10-18 00:00:00 | 55000
138 | 2022-11-01 00:00:00 | 50000
163 | 2022-11-27 00:00:00 | 50000
76 | 2022-12-09 00:00:00 | 45000
77 | 2022-12-09 00:00:00 | 45000
78 | 2022-12-09 00:00:00 | 45000
79 | 2022-12-09 00:00:00 | 45000
80 | 2022-12-09 00:00:00 | 45000
81 | 2022-12-09 00:00:00 | 45000
127 | 2022-12-09 00:00:00 | 50000
135 | 2022-12-12 00:00:00 | 50000
170 | 2022-12-12 00:00:00 | 50000
129 | 2022-12-15 00:00:00 | 50000
131 | 2022-12-15 00:00:00 | 50000
192 | 2022-12-15 00:00:00 | 50000
193 | 2022-12-15 00:00:00 | 50000
172 | 2022-12-16 00:00:00 | 50000
188 | 2022-12-21 00:00:00 | 50000
189 | 2022-12-22 00:00:00 | 50000
224 | 2022-12-28 00:00:00 | 40000
212 | 2022-12-29 00:00:00 | 40000
225 | 2022-12-30 00:00:00 | 40000
190 | 2023-01-10 00:00:00 | 50000
133 | 2023-01-19 00:00:00 | 50000
110 | 2023-02-01 00:00:00 | 30000
177 | 2023-02-01 00:00:00 | 50000
223 | 2023-02-16 00:00:00 | 40000
123 | 2023-02-20 00:00:00 | 50000
156 | 2023-02-20 00:00:00 | 45000
215 | 2023-02-20 00:00:00 | 40000
19 | 2023-03-01 00:00:00 | 70000
115 | 2023-03-01 00:00:00 | 30000
128 | 2023-03-01 00:00:00 | 50000
145 | 2023-03-01 00:00:00 | 45000
140 | 2023-03-08 00:00:00 | 45000
142 | 2023-03-08 00:00:00 | 45000
143 | 2023-03-08 00:00:00 | 45000
144 | 2023-03-08 00:00:00 | 45000
148 | 2023-03-08 00:00:00 | 45000
10 | 2023-03-20 00:00:00 | 55000
26 | 2023-04-04 00:00:00 | 50000
33 | 2023-04-04 00:00:00 | 35000
34 | 2023-04-04 00:00:00 | 35000
36 | 2023-04-04 00:00:00 | 45000
44 | 2023-04-04 00:00:00 | 70000
161 | 2023-04-04 00:00:00 | 50000
45 | 2023-04-12 00:00:00 | 45000
155 | 2023-04-13 00:00:00 | 45000
62 | 2023-04-25 00:00:00 | 45000
63 | 2023-04-25 00:00:00 | 45000
64 | 2023-04-25 00:00:00 | 45000
20 | 2023-05-01 00:00:00 | 55000
90 | 2023-05-01 00:00:00 | 50000
97 | 2023-05-01 00:00:00 | 50000
146 | 2023-05-01 00:00:00 | 45000
147 | 2023-05-01 00:00:00 | 45000
132 | 2023-05-08 00:00:00 | 50000
191 | 2023-05-08 00:00:00 | 50000
48 | 2023-05-17 00:00:00 | 60000
216 | 2023-05-17 00:00:00 | 40000
46 | 2023-05-18 00:00:00 | 45000
29 | 2023-06-01 00:00:00 | 20000
30 | 2023-06-01 00:00:00 | 20000
89 | 2023-06-01 00:00:00 | 45000
150 | 2023-06-01 00:00:00 | 45000
202 | 2023-06-01 00:00:00 | 60000
214 | 2023-06-01 00:00:00 | 40000
220 | 2023-06-01 00:00:00 | 40000
221 | 2023-06-01 00:00:00 | 40000
82 | 2023-06-07 00:00:00 | 45000
83 | 2023-06-07 00:00:00 | 45000
84 | 2023-06-07 00:00:00 | 45000
85 | 2023-06-07 00:00:00 | 45000
86 | 2023-06-07 00:00:00 | 45000
87 | 2023-06-07 00:00:00 | 45000
88 | 2023-06-07 00:00:00 | 45000
16 | 2023-06-21 00:00:00 | 55000
17 | 2023-06-21 00:00:00 | 55000
18 | 2023-06-24 00:00:00 | 55000
21 | 2023-07-01 00:00:00 | 55000
72 | 2023-07-01 00:00:00 | 45000
151 | 2023-07-01 00:00:00 | 45000
211 | 2023-07-17 00:00:00 | 40000
217 | 2023-07-24 00:00:00 | 40000
102 | 2023-08-01 00:00:00 | 40000
171 | 2023-08-01 00:00:00 | 50000
199 | 2023-08-01 00:00:00 | 50000
200 | 2023-08-01 00:00:00 | 50000
178 | 2023-08-11 00:00:00 | 50000
179 | 2023-08-11 00:00:00 | 50000
55 | 2023-09-01 00:00:00 | 50000
75 | 2023-09-01 00:00:00 | 45000
96 | 2023-09-01 00:00:00 | 50000
149 | 2023-09-01 00:00:00 | 45000
203 | 2023-09-01 00:00:00 | 30000
208 | 2023-10-01 00:00:00 | 55000
209 | 2023-10-01 00:00:00 | 15000
22 | 2023-10-03 00:00:00 | 55000
130 | 2023-10-03 00:00:00 | 50000
141 | 2023-10-03 00:00:00 | 45000
23 | 2023-10-04 00:00:00 | 52500
24 | 2023-10-04 00:00:00 | 52500
 | Total