Spreadsheet: 693993d1599255234-need-formula-to-create-performance-chart-of-employees-sales-related-salesman-perfomance-report-july-and-aug-20-eba
Sheet: Sheet2

S. No | L.No. | Customer | [NAME] | Nationality | [NAME] receive date | License receive date | Salesman | Sale Start Date | Sale End Date | No. of Days | Supervisor |  | Salesman | Sales | Days | Percentage
1 | L_116198 | [NAME] SINGH | 2020-01-22 00:00:00 | INDIAN | 2020-01-22 00:00:00 | 2020-07-20 00:00:00 | Raha
2 | L_116499 | [NAME] | 2020-01-24 00:00:00 | INDIAN | 2020-01-24 00:00:00 | 2020-07-27 00:00:00 | S.Raha
3 | L_116501 | [NAME] ALAM JALALUUDDIN | 2020-01-24 00:00:00 | INDIAN | 2020-01-24 00:00:00 | 2020-07-05 00:00:00 | Asif | 2020-06-28 00:00:00 | 2020-07-05 00:00:00 | 5
4 | [NAME] | SABBIR AHMAD SALAHUDDIN | 2020-01-24 00:00:00 | INDIAN | 2020-01-24 00:00:00 | 2020-07-12 00:00:00 | Asif | 2020-06-28 00:00:00 | 2020-07-12 00:00:00 | 10
5 | L_116787 | MOHMMAD [NAME] | 2020-01-27 00:00:00 | INDIAN | 2020-01-27 00:00:00 | 2020-07-26 00:00:00 | Asif | 2020-07-14 00:00:00 | 2020-07-26 00:00:00 | 8
6 | L_116850 | SHAHUL HAMEED ABDUL KADHER | 2020-01-29 00:00:00 | INDIAN | 2020-01-29 00:00:00 | 2020-07-12 00:00:00 | Shabbir | 2020-07-07 00:00:00 | 2020-07-12 00:00:00 | 5
7 | L_117209 | SK RAKIBUDDIN SK JOYNAL ABEDIN | 2020-01-31 00:00:00 | INDIAN | 2020-01-31 00:00:00 | 2020-07-27 00:00:00 | S.Raha
8 | L_117213 | NAUSHAD ALAM KALAMUDDIN | 2020-01-31 00:00:00 | INDIAN | 2020-01-31 00:00:00 | 2020-07-12 00:00:00 | Asif | 2020-06-28 00:00:00 | 2020-07-12 00:00:00 | 10
9 | L_118371 | EKRAMUL MOHD JALIL AHMAD | 2020-02-19 00:00:00 | INDIAN | 2020-02-19 00:00:00 | 2020-07-20 00:00:00 | Raha
10 | L_118421 | MOHD ARIF NAVI HASAN | 2020-02-21 00:00:00 | INDIAN | 2020-02-21 00:00:00 | 2020-07-01 00:00:00 | Shabbir | 2020-06-28 00:00:00 | 2020-07-01 00:00:00 | 3
11 | L_118424 | ROSHAN DHARMENDRA KUMAR | 2020-02-21 00:00:00 | INDIAN | 2020-02-21 00:00:00 | 2020-07-12 00:00:00 | Asif | 2020-06-28 00:00:00 | 2020-07-12 00:00:00 | 10
12 | L_118523 | SANDIP KUMAR KESHANPAL | 2020-02-24 00:00:00 | INDIAN | 2020-02-24 00:00:00 | 2020-07-06 00:00:00 | Shabbir | 2020-06-28 00:00:00 | 2020-07-06 00:00:00 | 6
13 | L_118817 | ANOOP KUMAR SAHAB SARAN | 2020-02-27 00:00:00 | INDIAN | 2020-02-27 00:00:00 | 2020-07-12 00:00:00 | Ghani | 2020-07-07 00:00:00 | 2020-07-12 00:00:00 | 3
14 | [NAME] | SANDEEP KUMAR SINGH | 2020-03-01 00:00:00 | INDIAN | 2020-03-01 00:00:00 | 2020-07-07 00:00:00 | Asif | 2020-07-01 00:00:00 | 2020-07-07 00:00:00 | 4
15 | L_119504 | INTJAR KAHN ISRAR KHA | 2020-03-08 00:00:00 | INDIAN | 2020-03-08 00:00:00 | 2020-07-26 00:00:00 | [NAME] | 2020-07-20 00:00:00 | 2020-07-26 00:00:00 | 4
16 | L_119608 | DILAWAR HUSSAIN PIRAN DITTA | 2020-03-09 00:00:00 | PAKISTAN | 2020-03-09 00:00:00 | 2020-07-05 00:00:00 | Shabbir | 2020-07-01 00:00:00 | 2020-07-05 00:00:00 | 2
17 | L_118425 | VIRENDRA VISHRAM PASI | 2020-02-21 00:00:00 | INDIAN | 2020-02-21 00:00:00 | 2020-07-20 00:00:00 | Raha
18 | L_118431 | [NAME] | 2020-02-21 00:00:00 | INDIAN | 2020-02-21 00:00:00 | 2020-07-12 00:00:00 | Ghani | 2020-07-07 00:00:00 | 2020-07-12 00:00:00 | 3
19 | L_118525 | WASEEM MOHAMMAD SHAREEF | 2020-02-24 00:00:00 | INDIAN | 2020-02-24 00:00:00 | 2020-07-20 00:00:00 | Raha
20 | L_118818 | RAJU MATADEEN SAROJ | 2020-02-27 00:00:00 | INDIAN | 2020-02-27 00:00:00 | 2020-07-20 00:00:00 | Raha
21 | L_118820 | SONU GUDDU AHMAD | 2020-02-27 00:00:00 | INDIAN | 2020-02-27 00:00:00 | 2020-07-26 00:00:00 | Asif | 2020-07-07 00:00:00 | 2020-07-26 00:00:00 | 19
22 | L_118998 | AJAHARUDDIN AKABAL AHAMAD | 2020-02-29 00:00:00 | INDIAN | 2020-02-29 00:00:00 | 2020-07-19 00:00:00 | Shabbir | 2020-07-07 00:00:00 | 2020-07-19 00:00:00 | 12
23 | [NAME] | SANVAR ALI JALEEL ALI | 2020-02-29 00:00:00 | INDIAN | 2020-02-29 00:00:00 | 2020-07-12 00:00:00 | Shabbir | 2020-07-07 00:00:00 | 2020-07-12 00:00:00 | 5
24 | L_119601 | [NAME] ULLAH | 2020-03-09 00:00:00 | INDIAN | 2020-03-09 00:00:00 | 2020-07-20 00:00:00 | Raha
25 | L_119411 | MAROOF AAJAM MODH IDREES | 2020-03-06 00:00:00 | INDIAN | 2020-03-06 00:00:00 | 2020-07-26 00:00:00 | [NAME] | 2020-07-20 00:00:00 | 2020-07-26 00:00:00 | 4
26 | L_119069 | [NAME] | 2020-02-29 00:00:00 | UGANDA | 2020-02-29 00:00:00 | 2020-07-19 00:00:00 | [NAME] | 2020-07-12 00:00:00 | 2020-07-19 00:00:00 | 5
27 | L_119626 | HAMISI KASULE | 2020-03-11 00:00:00 | UGANDA | 2020-03-11 00:00:00 | 2020-07-26 00:00:00 | [NAME] | 2020-07-20 00:00:00 | 2020-07-26 00:00:00 | 4
28 | L_119412 | NURAALAM MOJAHIR | 2020-03-06 00:00:00 | INDIAN | 2020-03-06 00:00:00 | 2020-07-26 00:00:00 | Shabbir | 2020-07-20 00:00:00 | 2020-07-26 00:00:00 | 4
29 | L_119594 | MOHHAMAD KARIM KAMARUDDIN | 2020-03-09 00:00:00 | INDIAN | 2020-03-09 00:00:00 | 2020-07-26 00:00:00 | Shabbir | 2020-07-20 00:00:00 | 2020-07-26 00:00:00 | 4
30 | L_118995 | FAISAL [NAME] | 2020-02-27 00:00:00 | INDIAN | 2020-02-27 00:00:00 | 2020-07-26 00:00:00 | Asif | 2020-07-20 00:00:00 | 2020-07-26 00:00:00 | 4
31 | L_119408 | AANAND VIN LANGATU VIN | 2020-03-06 00:00:00 | INDIAN | 2020-03-06 00:00:00 | 2020-07-27 00:00:00 | S.Raha
32 | [NAME] | SHAFIQ CHOUHAN RAFIQ | INDIAN | INDIAN | 2020-07-08 00:00:00 | 2020-07-19 00:00:00 | Ghani | 2020-07-20 00:00:00 | 2020-08-04 00:00:00 | 11
33 | L_119083 | ALI AKBAR RASOOL BAKHSH | PAKISTAN | PAKISTAN | 2020-07-08 00:00:00 | 2020-07-19 00:00:00 | Shabbir | 2020-07-20 00:00:00 | 2020-08-04 00:00:00 | 11
34 | L_118219 | SONU KUMAR SHANKAR | INDIAN | INDIAN | 2020-07-08 00:00:00 | 2020-07-19 00:00:00 | Asif | 2020-07-21 00:00:00 | 2020-08-04 00:00:00 | 10
35 | L_119598 | DHARAM RAJ SINGH | INDIAN | INDIAN | 2020-07-06 00:00:00 | 2020-07-19 00:00:00 | Ghani | 2020-07-21 00:00:00 | 2020-08-04 00:00:00 | 10
36 | L_116931 | BAJI BASHA SHAIK | INDIAN | INDIAN | 2020-02-27 00:00:00 | 2020-07-20 00:00:00 | [NAME] | 2020-07-26 00:00:00 | 2020-08-04 00:00:00 | 5
37 | L_117051 | ROHIT KUMAR [NAME] | INDIAN | INDIAN | 2020-07-13 00:00:00 | 2020-07-22 00:00:00 | Asif | 2020-07-26 00:00:00 | 2020-08-04 00:00:00 | 5
38 | L_117054 | MUHAMMAD KHALIK SALIM | INDIAN | INDIAN | 2020-07-13 00:00:00 | 2020-07-22 00:00:00 | Shabbir | 2020-07-26 00:00:00 | 2020-08-04 00:00:00 | 5
39 | L_119593 | KAMLESH KUMAR MOLAI | INDIAN | INDIAN | 2020-07-13 00:00:00 | 2020-07-22 00:00:00 | [NAME] | 2020-07-26 00:00:00 | 2020-08-04 00:00:00 | 5
40 | L_118527 | PAVAN KUMAR DASARI | INDIAN | INDIAN | 2020-03-04 00:00:00 | 2020-07-22 00:00:00 | Asif | 2020-07-26 00:00:00 | 2020-08-04 00:00:00 | 5
41 | L_118426 | SANJAY YADAV LAL BAHADUR | INDIAN | INDIAN | 2020-07-08 00:00:00 | 2020-07-19 00:00:00 | Ghani | 2020-07-20 00:00:00 | 2020-08-09 00:00:00 | 14
42 | L_116681 | [NAME] | INDIAN | INDIAN | 2020-03-02 00:00:00 | 2020-07-22 00:00:00 | Shabbir | 2020-07-26 00:00:00 | 2020-08-09 00:00:00 | 8 | Asif
43 | L_118074 | [NAME] | 2020-02-13 00:00:00 | INDIAN | 2020-07-19 00:00:00 | 2020-08-09 00:00:00 | Ghani | 2020-08-11 00:00:00 | 2020-08-16 00:00:00 |  | Asif
44 | [NAME] | MOHAMMAD ZAID MOHAMMAD ATEEK | 2020-02-21 00:00:00 | INDIAN | 2020-07-19 00:00:00 | 2020-08-09 00:00:00 | Shabbir | 2020-08-11 00:00:00 | 2020-08-16 00:00:00 |  | Asif
45 | L_118420 | MOHAMMAD SAMEER SHAKIL | 2020-02-21 00:00:00 | INDIAN | 2020-07-20 00:00:00 | 2020-08-09 00:00:00 | Shabbir | 2020-08-11 00:00:00 | 2020-08-16 00:00:00 |  | Asif
46 | L_118071 | SARFARAJ ALI MOHAMMAD SULTAN | 2020-02-14 00:00:00 | INDIAN | 2020-07-20 00:00:00 | 2020-08-09 00:00:00 | Shabbir | 2020-08-11 00:00:00 | 2020-08-16 00:00:00 |  | Asif
47 | L_118239 | MOHAMMAD ARIF NOOR ALI | 2020-02-16 00:00:00 | INDIAN | 2020-03-04 00:00:00 | 2020-08-09 00:00:00 | [NAME] | 2020-08-11 00:00:00 | 2020-08-16 00:00:00 |  | Asif
48 | [NAME] | BHOLA NATH DHARAMARAJ YADAV | 2020-01-31 00:00:00 | INDIAN | 2020-02-25 00:00:00 | 2020-08-10 00:00:00 | [NAME] | 2020-08-11 00:00:00 | 2020-08-16 00:00:00 |  | Asif
49 | [NAME] | MOHD SHAFEEQ MOHAMMAD LATEEF | 2020-02-19 00:00:00 | INDIAN | 2020-07-20 00:00:00 | 2020-08-09 00:00:00 | Shabbir | 2020-08-11 00:00:00 | 2020-08-19 00:00:00 |  | Asif
50 | L_119609 | FARAZ [NAME] | 2020-03-09 00:00:00 | PAKISTAN | 2020-07-20 00:00:00 | 2020-08-09 00:00:00 | [NAME] | 2020-08-11 00:00:00 | 2020-08-19 00:00:00 |  | Asif
51 | [NAME] | SYED ZEESHAN AHMAD | 2020-02-23 00:00:00 | INDIAN | 2020-03-04 00:00:00 | 2020-08-10 00:00:00 | [NAME] | 2020-08-11 00:00:00 | 2020-08-19 00:00:00 |  | Asif
52 | L_119414 | PRAVESH KUMAR CHHOTE LAL | 2020-03-06 00:00:00 | INDIAN | 2020-07-07 00:00:00 | 2020-08-09 00:00:00 | Bania | 2020-08-11 00:00:00 | 2020-08-23 00:00:00 | 8 | Asif
53 | L_118935 | MANIK LAL BACHCHI LAL | 2020-02-29 00:00:00 | INDIAN | 2020-07-08 00:00:00 | 2020-08-09 00:00:00 | Bania | 2020-08-11 00:00:00 | 2020-08-23 00:00:00 | 8 | Asif
54 | L_118238 | MASOOM ABDULLA | 2020-02-16 00:00:00 | INDIAN | 2020-03-04 00:00:00 | 2020-08-12 00:00:00 | Shabbir | 2020-08-16 00:00:00 | 2020-08-23 00:00:00 | 5 | Asif
55 | L_119623 | [NAME] | 2020-03-11 00:00:00 | UGANDA | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | Shabbir | 2020-08-20 00:00:00 | 2020-08-23 00:00:00 | n | Asif
56 | L_119625 | FRANK KASANWA | 2020-03-11 00:00:00 | UGANDA | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | Asif | 2020-08-23 00:00:00 | 2020-08-25 00:00:00 | 2 | Asif
57 | L_119631 | NAJIB SSENGONZI | 2020-03-11 00:00:00 | UGANDA | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | Shabbir | 2020-08-23 00:00:00 | 2020-08-25 00:00:00 | 2 | Asif
58 | L_119632 | RAULES BWAMBALE | 2020-03-11 00:00:00 | UGANDA | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | Shabbir | 2020-08-23 00:00:00 | 2020-08-25 00:00:00 | 2 | Asif
59 | L_119633 | RAULES BWAMBALE | 2020-03-12 00:00:00 | UGANDA | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | Shabbir2 | 2020-08-23 00:00:00 | 2020-08-25 00:00:00 | 3 | Asif
60 | L_119634 | RAULES BWAMBALE | 2020-03-13 00:00:00 | UGANDA | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | Shabbir3 | 2020-08-23 00:00:00 | 2020-08-25 00:00:00 | 4 | Asif