Spreadsheet: 854859d1704617011-lookup-and-find-the-in-between-days-and-return-number-of-days-20240105-ans
Sheet: JA(VS) (2)

 | Special Working Report |  |  |  |  |  | 1st |  |  |  | 2nd |  |  |  | 3rd |  |  |  | 4th |  |  |  | 5th |  |  |  | 6th
Sr No. | Emp. No. | Employee Name | Designation | Location | Date Of Joining | Releived | Completed 6 Month | LWP | Actual Date | Report | Completed 6 Month | LWP | Actual Date | Report | Completed 6 Month | LWP | Actual Date | Report | Completed 6 Month | LWP | Actual Date | Report | Completed 6 Month | LWP | Actual Date | Report | Completed 6 Month | LWP | Actual Date | Report | Total LWP | Days | Diff
1 | 30122 | Mr. [NAME] MAGANBHAI CHAUDHARI | J.A(VS) | [NAME] (R) S/D | 2021-06-09 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
2 | 30117 | Miss MITTALBEN VIRMABHAI CHAUDHARI | J.A(VS) | Bhuj City-I S/D | 2021-06-09 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
3 | 30106 | Ms. [NAME] BATUKBHAI CHAUHAN | J.A(VS) | Bhujodi S/D | 2021-06-09 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
4 | 30114 | Miss [NAME] VAISHNAV | J.A(VS) | Kukma S/Dn. | 2021-06-09 00:00:00 |  |  |  |  |  |  | 36 |  |  |  | 0 |  |  |  | 0
5 | 30119 | Mr. [NAME] JADAV | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-09 00:00:00 |  |  | 17 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
6 | 30123 | Mr. [NAME] SANGANI | J.A(VS) | Bhuj City-I S/D | 2021-06-10 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
7 | 30124 | Miss [NAME] HARESHGIRI GOSWAMI | J.A(VS) | Bhuj City-I S/D | 2021-06-10 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
8 | 30145 | Ms. PALLAVI LAXMANBHAI SUMESARA | J.A(VS) | Bhuj City-II S/D | 2021-06-10 00:00:00 |  |  | 0 |  | TO BE SENT |  | 0 |  |  |  | 0 |  |  |  | 0
9 | 30150 | Ms. [NAME] PARMAR | J.A(VS) | Bhuj City-II S/D | 2021-06-10 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
10 | 30153 | Miss [NAME] | J.A(VS) | Bhuj City-II S/D | 2021-06-10 00:00:00 |  |  | 54 |  |  |  | 0 |  |  |  | 0 |  |  |  | 91
11 | 30143 | Ms. [NAME] GARODA | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-10 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
12 | 30156 | Mr. [NAME] VAGHELA | J.A(VS) | [NAME] (R) S/D | 2021-06-11 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
13 | 30163 | Mr. [NAME] | J.A(VS) | Bhuj City-I S/D | 2021-06-11 00:00:00 |  |  | 31 |  | TO BE SENT |  | 0 |  |  |  | 0 |  |  |  | 0
14 | 30166 | Mr. [NAME] BHAYABHAI BARIYA | J.A(VS) | Bhuj City-I S/D | 2021-06-11 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
15 | 30159 | Mr. [NAME] PANACHAND PARMAR | J.A(VS) | Bhuj City-II S/D | 2021-06-11 00:00:00 |  |  | 25 |  |  |  | 36 |  |  |  | 0
16 | 30161 | Mr. [NAME] VANAGARA | J.A(VS) | Bhuj City-II S/D | 2021-06-11 00:00:00 |  |  | 5 |  | TO BE SENT |  | 0 |  |  |  | 0
17 | 30162 | Mr. [NAME] CHANDULAL HADIYAL | J.A(VS) | Bhuj City-II S/D | 2021-06-11 00:00:00 |  |  | 0 |  | TO BE SENT |  | 0 |  |  |  | 0
18 | 30164 | Mr. [NAME] RAMANBHAI PRAJAPATI | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-11 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
19 | 30165 | Mr. [NAME] MADHAVLAL JOSHI | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-11 00:00:00 |  |  | 20 |  | YES |  | 69 |  |  |  | 32
20 | 30361 | Miss JIGNASA JAYANTILAL FALIYA | J.A(VS) | [NAME] (R) S/D | 2021-06-17 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
21 | 30362 | Mrs. [NAME] PANKAJBHAI JOSHI | J.A(VS) | [NAME] (R) S/D | 2021-06-17 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
22 | 30368 | Ms. [NAME] CHAVDA | J.A(VS) | [NAME] (R) S/D | 2021-06-17 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
23 | 30369 | Ms. [NAME] ANDANI | J.A(VS) | [NAME] (R) S/D | 2021-06-17 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
24 | 30370 | Mr. [NAME] KANTILAL BHATIYA | J.A(VS) | [NAME] (R) S/D | 2021-06-17 00:00:00 |  |  | 28 |  |  |  | 0 |  |  |  | 0
25 | 30372 | Ms. [NAME] SOLANKI | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-17 00:00:00 |  |  | 5 |  |  |  | 29 |  |  |  | 0
26 | 30377 | Mr. [NAME] PARMAR | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-17 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  | 10
27 | 30381 | Miss MANISHABEN MAGANLAL MARU | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-17 00:00:00 |  |  | 3 |  |  |  | 0 |  |  |  | 19
28 | 30383 | Mr. [NAME] BISMILLASHA FAKIR | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-18 00:00:00 |  |  | 5 |  |  |  |  |  |  |  | 0
29 | 30765 | Ms. [NAME] | J.A(VS) | Bhujodi S/D | 2021-06-24 00:00:00 |  |  | 12 |  |  |  | 0 |  |  |  | 20 |  |  |  | 8
30 | 30674 | Miss VANDNABEN PRAVINGIRI GOSWAMI | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-24 00:00:00 |  |  | 7 |  |  |  | 0 |  |  |  | 0
31 | 30672 | Miss SWEETUBA INDRASINH JADEJA | J.A(VS) | Deshalpar S/D | 2021-06-25 00:00:00 |  |  | 121 |  |  |  | 0 |  |  |  | 0
32 | 30675 | Miss VAISHALI MANSUKHBHAI SOLANKI | J.A(VS) | Kukma S/Dn. | 2021-06-25 00:00:00 |  |  | 26 |  |  |  | 30 |  |  |  | 0
33 | 30676 | Miss MEGHA PANKAJBHAI GOHEL | J.A(VS) | Kukma S/Dn. | 2021-06-25 00:00:00 |  |  | 142 |  |  |  | 0 |  |  |  | 0
34 | 30678 | Miss DAKSHABEN DHIRUBHAI VAGHELA | J.A(VS) | Kukma S/Dn. | 2021-06-25 00:00:00 |  |  | 19 |  |  |  | 0 |  |  |  | 0
35 | 30761 | Ms. PURVI MANUBHAI AKHANI | J.A(VS) | [NAME] (R) S/D | 2021-07-08 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
36 | 30726 | Mr. [NAME] KARSHANBHAI SAGARKA | J.A(VS) | Bhujodi S/D | 2021-07-08 00:00:00 |  |  | 6 |  |  |  | 0 |  |  |  | 0
37 | 30741 | Mr. [NAME] JANI | J.A(VS) | Bhujodi S/D | 2021-07-08 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
38 | 30759 | Mr. [NAME] BHAGVANBHAI PARMAR | J.A(VS) | Bhujodi S/D | 2021-07-08 00:00:00 |  |  | 16 |  | TO BE SENT |  | 0 |  | TO BE SENT |  | 0
39 | 30740 | Mr. [NAME] MARU | J.A(VS) | Kukma S/Dn. | 2021-07-08 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 20
40 | 30757 | Mr. [NAME] NAKUM | J.A(VS) | [NAME] (R) S/D | 2021-07-09 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
41 | 30733 | Ms. [NAME] [NAME] | J.A(VS) | Bhujodi S/D | 2021-07-09 00:00:00 |  |  | 149 |  |  |  | 0 |  |  |  | 0
42 | 30744 | Mr. [NAME] RAMESHBHAI NANNERA | J.A(VS) | Bhujodi S/D | 2021-07-09 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
43 | 30728 | Mr. [NAME] HAMIRAJI RABARI | J.A(VS) | Deshalpar S/D | 2021-07-09 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
44 | 30756 | Mr. [NAME] MAGANBHAI RATHOD | J.A(VS) | Kukma S/Dn. | 2021-07-09 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
45 | 30727 | Mrs. HEMAXIBEN [NAME] | J.A(VS) | Deshalpar S/D | 2021-07-13 00:00:00 |  |  | 179 |  |  |  | 0 |  |  |  | 0
46 | 30743 | Ms. [NAME] UPADHYAY | J.A(VS) | Deshalpar S/D | 2021-07-13 00:00:00 |  |  | 0 |  | TO BE SENT |  | 0 |  |  |  | 0
47 | 30732 | Mr. VIPUL KANJIBHAI SUSARA | J.A(VS) | Bhujodi S/D | 2021-07-17 00:00:00 |  |  | 32 |  | TO BE SENT |  | 0 |  |  |  | 0
48 | 30745 | Mr. [NAME] DODIYA | J.A(VS) | Bhujodi S/D | 2021-07-17 00:00:00 |  |  | 0 |  | YES |  | 0 |  |  |  | 0
49 | 30746 | Ms. KANCHANBEN DANABHAI VALA | J.A(VS) | Deshalpar S/D | 2021-07-17 00:00:00 |  |  | 0 |  | TO BE SENT |  | 0 |  |  |  | 0
50 | 30751 | Miss HIRALBEN NUTANBHAI [NAME] | J.A(VS) | Madhapar (Bhuj) S/D | 2021-07-17 00:00:00 |  |  | 22 |  |  |  | 0 |  |  |  | 0
51 | 30823 | Mr. [NAME] PARMAR | J.A(VS) | Deshalpar S/D | 2021-08-03 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
52 | 30813 | Mr. [NAME] JAYANTILAL NAKUM | J.A(VS) | [NAME] | 2021-08-05 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
53 | 31614 | Miss MOHSINA ABDULKARIM HINGORA | J.A(VS) | [NAME] (R) S/D | 2021-10-21 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 24
54 | 31613 | Miss DIVYABA NARENDRASINH JADEJA | J.A(VS) | Bhuj City-I S/D | 2021-10-21 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
55 | 31612 | Mr. [NAME] RAMDHANI YADAV | J.A(VS) | Bhuj City-II S/D | 2021-10-21 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
56 | 31616 | Mrs. [NAME] SOLANKI | J.A(VS) | Bhujodi S/D | 2021-10-21 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
57 | 31615 | Miss JAHAL KAUSHIKBHAI MAHETA | J.A(VS) | Deshalpar S/D | 2021-10-21 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 30
58 | 31617 | Mrs. [NAME] RAMESHBHAI [NAME] | J.A(VS) | [NAME] (R) S/D | 2021-10-25 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
59 | 31621 | Mr. [NAME] DHIRUBHAI DHORIYA | J.A(VS) | [NAME] (R) S/D | 2021-10-25 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
60 | 32049 | Miss KHERUNNISHA MOHAMMEDSALIM MEMON | J.A(VS) | [NAME] (R) S/D | 2021-11-22 00:00:00 |  |  | 0 |  |  |  | 0 |  |  |  | 0
61 | 32947 | Mr. [NAME] NARAN BHARAI | J.A(VS) | Bhuj City-II S/D | 2022-03-10 00:00:00 |  |  | 48 |  |  |  | 0 |  |  |  | 0
62 | 32953 | Miss PARUL AMARSINGBHAI RATHWA | J.A(VS) | Kukma S/Dn. | 2022-03-14 00:00:00 |  |  | 0 |  |  |  | 0 |  | YES |  | 7
63 | 32956 | Mr. [NAME] BHUPENDRABHAI KHAMBHALA | J.A(VS) | Kukma S/Dn. | 2022-03-15 00:00:00 |  |  | 30 |  |  |  | 0 |  |  |  | 0
64 | 33069 | Miss TRUPTI CHATURBHAI KAILA | J.A(VS) | [NAME] (R) S/D | 2022-03-25 00:00:00 |  |  | 30 |  |  |  | 0 |  |  |  | 0
65 | 30247 | Ms. [NAME] DABHI | J.A(VS) | [NAME] (R) S/D | 2021-06-18 00:00:00 |  |  | 98 |  |  |  | 25
66 | 30617 | Mr. [NAME] CHAUHAN | J.A(VS) | Kukma S/Dn. | 2021-07-13 00:00:00 |  |  | 87 |  |  |  | 102 |  |  |  | 6
67 | 30704 | Mr. [NAME] SUMRA | J.A(VS) | [NAME] (R) S/D | 2021-07-12 00:00:00
68 | 30706 | Mrs. [NAME] SHAMBHUBHAI CHAVDA | J.A(VS) | Kukma S/Dn. | 2021-07-13 00:00:00
69 | 32160 | Miss POOJA SATISHBHAI DHOLAKIA | J.A(VS) | [NAME] (R) S/D | 2021-11-22 00:00:00
70 | 32228 | Mr. [NAME] DAMOR | J.A(VS) | [NAME] (R) S/D | 2021-11-23 00:00:00 |  |  | 32 |  |  |  | 9
71 | 32857 | Mr. [NAME] RATHOD | J.A(VS) | Bhujodi S/D | 2022-03-03 00:00:00 |  |  | 54
72 | 32867 | Mrs. [NAME] BHAVIK VORA | J.A(VS) | Bhuj Division | 2022-03-05 00:00:00
73 | 32877 | Miss DISHA GIRISHKUMAR TANK | J.A(VS) | [NAME] (R) S/D | 2022-03-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | YES
74 | 32886 | Ms. [NAME] DESAI | J.A(VS) | [NAME] (R) S/D | 2022-03-08 00:00:00 |  |  | 44
75 | 32900 | Miss [NAME] MAHESHWARI | J.A(VS) | Bhuj City-II S/D | 2022-03-11 00:00:00
76 | 33064 | Miss NAFISA ABDULKARIM HINGORA | J.A(VS) | [NAME] (R) S/D | 2022-03-28 00:00:00 |  |  | 6 |  |  |  | 16
77 | 34775 | Mr. [NAME] PINAKIN ADARSH | J.A(VS) | Madhapar (Bhuj) S/D | 2022-10-11 00:00:00 |  |  | 5
78 | 35004 | Miss SWETA PRABHUDAS HIRPARA | J.A(VS) | Khavda Sectional Office | 2022-10-27 00:00:00
79 | 35821 | Mr. [NAME] JAYANTIBHAI PARIKH | J.A(VS) | Kukma S/Dn. | 2022-12-22 00:00:00
80 | 35826 | Mr. [NAME] | J.A(VS) | Kukma S/Dn. | 2022-12-23 00:00:00 |  |  |  |  |  |  | 9
81 | 35828 | Mr. [NAME] MANUBHAI KARELIYA | J.A(VS) | Kukma S/Dn. | 2023-01-02 00:00:00
82 | 35831 | Mr. [NAME] THAKOR | J.A(VS) | Bhujodi S/D | 2023-01-02 00:00:00
83 | 36079 | Ms. [NAME] BHATT | J.A(VS) | Bhuj City-I S/D | 2023-02-01 00:00:00
84 | 36087 | Mr. [NAME] MAKVANA | J.A(VS) | Deshalpar S/D | 2023-01-21 00:00:00
85 | 36582 | Mr. [NAME] KHIMANANDBHAI KARANGIYA | J.A(VS) | [NAME] (R) S/D | 2021-06-17 00:00:00
86 | 36670 | Ms. [NAME] RAMESHBHAI BHARAD | J.A(VS) | Madhapar (Bhuj) S/D | 2021-06-29 00:00:00
87 | 36675 | Ms. [NAME] | J.A(VS) | [NAME] (R) S/D | 2022-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35