Next Leave date

[sachin99]

Good Day Everyone,

I need a formula to get the next Leave date of an employee based on criteria.

1. Below is the table which shows date on which particular employee is on leave
2. Will enter date in other sheet in cell A2
3. we will also have employee name in this sheet
3. Cell next to employee name should give the next PL date for that employee depending on the date enter in the
Eg. 1. If Sachin is the employee and date enter in Celll A2 is 07-Jan-2018 then value in cell next to Sachin will be 10-Jan-2018

2. If Vikas is the employee and date enter in Celll A2 is 09-Jan-2018 then value in cell next to Sachin will be 12-Jan-2018

3. if the A2 cell is blank then today's date will be consider for calculation

Do let me know if you need any more information on my requirement.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Sachin[/TD]
[TD]Vikas[/TD]
[/TR]
[TR]
[TD]01-Jan-2018[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]02-Jan-2018[/TD]
[TD]PL[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]03-Jan-2018[/TD]
[TD]PL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]04-Jan-2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05-Jan-2018[/TD]
[TD][/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]06-Jan-2018[/TD]
[TD][/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]07-Jan-2018[/TD]
[TD][/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]08-Jan-2018[/TD]
[TD][/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]09-Jan-2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10-Jan-2018[/TD]
[TD]PL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11-Jan-2018[/TD]
[TD]PL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12-Jan-2018[/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 196"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Regards
Sachin

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[sachin99]

Hi ,

There is no error but the count which i am getting is wrong below is the output which i am getting

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Next PL[/TD]
[TD]Count of PL[/TD]
[TD]Actual PL count[/TD]
[/TR]
[TR]
[TD]07-01-2018[/TD]
[TD]Vikas[/TD]
[TD]11-01-2018[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]07-01-2018[/TD]
[TD]Sachin[/TD]
[TD]09-01-2018[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]07-01-2018[/TD]
[TD]Sunil[/TD]
[TD]08-01-2018[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD]07-01-2018[/TD]
[TD]Umesh[/TD]
[TD]09-01-2018[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[/TR]
</tbody>[/TABLE]

formula used : =COUNTIFS(INDEX(Sheet1!$B$2:$E$100,0,MATCH(B2,Sheet1!$B$1:$E$1,0)),"PL",Sheet1!$A$2:$A$100,"<"&A2)



[TABLE="width: 325"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Sachin[/TD]
[TD]Vikas[/TD]
[TD]Sunil[/TD]
[TD]Umesh[/TD]
[/TR]
[TR]
[TD]01-Jan-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]02-Jan-18[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]03-Jan-18[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]04-Jan-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05-Jan-18[/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]06-Jan-18[/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]07-Jan-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]08-Jan-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]09-Jan-18[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]10-Jan-18[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]11-Jan-18[/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]12-Jan-18[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

----------------------------

Hi, what you can see in post 7 is a screen shot of the Excel file with the formula implemented.



What output are you getting?
- Is it an error? If so what is the error?
- Is it simply the wrong result? If so, can you post example data that demonstrates this and state what the correct result should be?
- Is it something else? If so, what are the details?

If your layout is different to post 7 and you have attempted to alter the formula to your actual set-up then post the formula that you are trying and describe in detail your exact layout.

 

[FormR]

Hi, looks like you want:

=COUNTIFS(INDEX(Sheet1!$B$2:$E$100,0,MATCH(B2,Sheet1!$B$1:$E$1,0)),"PL",Sheet1!$A$2:$A$100,">"&A2)

Which is different to the example you gave in post 4.

 

[sachin99]

Hi, looks like you want:

=COUNTIFS(INDEX(Sheet1!$B$2:$E$100,0,MATCH(B2,Sheet1!$B$1:$E$1,0)),"PL",Sheet1!$A$2:$A$100,">"&A2)


Which is different to the example you gave in post 4.

----------------------------------------------------------------------------------

If i use this formula then it counts all PL from the given date..
Let me explain you my requirement again


1. I need the date on which PL is updated from date enter in cell A2 and if A2 is blank then it should consider todays date for calculation (Which your formula is giving correctly)


2. Need count of continues PLs from next PL date eg. if next PL Date for Sachin is 09-01-2018 and PL is updated till 11-Jan-2018 and 12-Jan is an empty cell then the PL count should be 3

Below is the table for your reference.

[TABLE="width: 325"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Sachin[/TD]
[TD]Vikas[/TD]
[TD]Sunil[/TD]
[TD]Umesh[/TD]
[/TR]
[TR]
[TD]01-Jan-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]02-Jan-18[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]03-Jan-18[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]04-Jan-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05-Jan-18[/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]06-Jan-18[/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]07-Jan-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]08-Jan-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]09-Jan-18[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]10-Jan-18[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]11-Jan-18[/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[TD] [/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]12-Jan-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]


The output Table

[TABLE="width: 314"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Employee[/TD]
[TD]Next PL[/TD]
[TD]Count Of PL[/TD]
[/TR]
[TR]
[TD]07-Jan-18[/TD]
[TD]Vikas[/TD]
[TD]11-Jan-18[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]07-Jan-18[/TD]
[TD]Sachin[/TD]
[TD]09-Jan-18[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]07-Jan-18[/TD]
[TD]Sunil[/TD]
[TD]08-Jan-18[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]07-Jan-18[/TD]
[TD]Umesh[/TD]
[TD]09-Jan-18[/TD]
[TD]3

[/TD]
[/TR]
</tbody>[/TABLE]

Apologies for any miscommunication ..

Thanks!!

Regards
Sachin

 

[FormR]

2. Need count of continues PLs from next PL date eg.

Hi, it's still not very clear to me, but maybe we should just be looking at the next PL date rather than the date? If not, post example data that demonstrates where that is not the case.

Excel 2013/2016
	A	B	C	D
1	Date	Employee	Next PL	Count Of PL
2	07/01/2018	Vikas	11/01/2018	1
3	07/01/2018	Sachin	09/01/2018	3
4	07/01/2018	Sunil	08/01/2018	2
5	07/01/2018	Umesh	09/01/2018	3
Sheet2

Cell Formulas
Range	Formula
D2	=COUNTIFS(INDEX(Sheet1!$B$2:$E$100,0,MATCH(B2,Sheet1!$B$1:$E$1,0)),"PL",Sheet1!$A$2:$A$100,">="&C2)

 

[sachin99]

Hi

Good Day Everyone,

Below is my requirement to get next PL date and count of continues PL from the next PL date as shown in the below table and output table

Below is the table which shows date on which particular employee is on leave

​

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD="align: center"]Date[/TD]
[TD="align: center"]Sachin[/TD]
[TD="align: center"]Vikas[/TD]
[TD="align: center"]Sunil[/TD]
[TD="align: center"]Umesh[/TD]
[/TR]
[TR]
[TD="align: center"]01-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]02-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]03-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]04-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]05-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]06-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]07-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]08-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]09-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]10-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]11-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]12-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]13-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]14-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]15-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]16-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]17-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]18-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]19-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]20-Jan-2018[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]21-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"]PL[/TD]
[/TR]
[TR]
[TD="align: center"]22-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]23-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]24-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]25-Jan-2018[/TD]
[TD="align: center"]PL[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]












































Below is the output table if i update Date as 07-Jan-2018

[TABLE="class: grid, width: 400, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Employee[/TD]
[TD]Next PL Date[/TD]
[TD]Count of PL[/TD]
[/TR]
[TR]
[TD]07-Jan-2018[/TD]
[TD]Sachin[/TD]
[TD]09-Jan-2018[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]07-Jan-2018[/TD]
[TD]VIkas[/TD]
[TD]15-Jan-2018[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]07-Jan-2018[/TD]
[TD]Sunil[/TD]
[TD]08-Jan-2018[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]07-Jan-2018[/TD]
[TD]Umesh[/TD]
[TD]09-Jan-2018[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]










Below is the output table if i update Date as 07-Jan-2018

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Employee[/TD]
[TD]Next PL[/TD]
[TD]Count of PL[/TD]
[/TR]
[TR]
[TD]14-Jan-2018[/TD]
[TD]Sachin[/TD]
[TD]21-Jan-2018[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]14-Jan-2018[/TD]
[TD]Vikas[/TD]
[TD]15-Jan-2018[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]14-Jan-2018[/TD]
[TD]Sunil[/TD]
[TD]19-Jan-2018[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]14-Jan-2018[/TD]
[TD]Umesh[/TD]
[TD]17-Jan-2018[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]










These are the samples as the employee count will me 50-60.


Regards
Sachin

 

[sachin99]

HI,

can i add excel , so that i can explain you in detail with examle to you

Regards
Sachin

 

[FormR]

can i add excel , so that i can explain you in detail with examle to you

Hi,

You can post screen shots using one of the methods described in post 2 here:
https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or you can continue to post example data in the same you already have been.

 

[sachin99]

Hi,

You can post screen shots using one of the methods described in post 2 here:
https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or you can continue to post example data in the same you already have been.[/QUOTE

• 
  I need a formula to search for next PL start date from the calender sheet of the attached file and in summary sheet will give desire details as per employee name
  
  Below is the calender table
  
  Date Vikas Sachin Sunil Umesh
  01-Jan-18 PL
  02-Jan-18 PL
  03-Jan-18 PL PL
  04-Jan-18
  05-Jan-18 PL PL
  06-Jan-18 PL PL
  07-Jan-18
  08-Jan-18 PL
  09-Jan-18 PL PL PL
  10-Jan-18 PL PL
  11-Jan-18 PL PL
  12-Jan-18
  13-Jan-18
  14-Jan-18
  15-Jan-18 PL
  16-Jan-18 PL
  17-Jan-18 PL PL
  18-Jan-18 PL PL
  19-Jan-18 PL PL PL
  20-Jan-18 PL PL PL
  21-Jan-18 PL PL PL
  22-Jan-18 PL PL
  23-Jan-18 PL PL
  24-Jan-18 PL
  25-Jan-18 PL
  
  
  Below is sample one when i update date as 07-Jan-2018 in date and below is the desire output
  
  Date Employee Next PL Count Of PL Example 1
  07-Jan-18 Vikas 09-Jan-18 3
  07-Jan-18 Sachin 15-Jan-18 6
  07-Jan-18 Sunil 08-Jan-18 2
  07-Jan-18 Umesh 09-Jan-18 3
  
  
  Below is sample two when i update date as 14-Jan-2018 in date and below is the desire output
  
  Date Employee Next PL Count Of PL Example 2
  14-Jan-18 Vikas 21-Jan-18 3
  14-Jan-18 Sachin 15-Jan-18 6
  14-Jan-18 Sunil 19-Jan-18 6
  14-Jan-18 Umesh 17-Jan-18 5
  
  so in both sample the count of PL is changes based on the date updated..
  
  Please note that the count of PL is number of PL in group Eg. have updated date as 07-Jan-2018 and in calener you can there are 3 PL updated from 9th to 11th Jan and then next PL is starting from 21-Jan .So the PL Count should be 3 for this .
  
  Regards
  Sachin​

 

[FormR]

That sample data has not posted well, can you try again?

Have you also posted this question to another forum?

 

[sachin99]

No , have not posted .. i just adding my comment on this thread

Hi ,

Below is the sample data.


below is calendar table

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Vikas[/TD]
[TD]Sachin[/TD]
[TD]Sunil[/TD]
[TD]Umesh[/TD]
[/TR]
[TR]
[TD]01-Jan-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]02-Jan-2018[/TD]
[TD]PL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03-Jan-2018[/TD]
[TD]PL[/TD]
[TD][/TD]
[TD]PL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]04-Jan-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05-Jan-2018[/TD]
[TD][/TD]
[TD]PL[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]06-Jan-2018[/TD]
[TD][/TD]
[TD]PL[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]07-Jan-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08-Jan-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]09-Jan-2018[/TD]
[TD]PL[/TD]
[TD][/TD]
[TD]PL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10-Jan-2018[/TD]
[TD]PL[/TD]
[TD][/TD]
[TD]PL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11-Jan-2018[/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]12-Jan-2018[/TD]
[TD][/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[TD]PL[/TD]
[/TR]
[TR]
[TD]13-Jan-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
























output Sample 1

if i updated date as 01-Jan-2018 then below will be the output

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Next PL Date[/TD]
[TD]Count of PL[/TD]
[/TR]
[TR]
[TD]01-Jan-2018[/TD]
[TD]Vikas[/TD]
[TD]02-01-2018[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]01-Jan-2018[/TD]
[TD]Sachin[/TD]
[TD]05-01-2018[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]01-Jan-2018[/TD]
[TD]Sunil[/TD]
[TD]01-01-2018[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]01-Jan-2018[/TD]
[TD]Umesh[/TD]
[TD]05-01-2018[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]


Output sample 2

if i updated date as 08-Jan-2018 then below will be the output

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Next PL Date[/TD]
[TD]Count of PL[/TD]
[/TR]
[TR]
[TD]08-Jan-2018[/TD]
[TD]Vikas[/TD]
[TD]09-01-2018[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]08-Jan-2018[/TD]
[TD]Sachin[/TD]
[TD]11-01-2018[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]08-Jan-2018[/TD]
[TD]Sunil[/TD]
[TD]09-01-2018[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]08-Jan-2018[/TD]
[TD]Umesh[/TD]
[TD]11-01-2018[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]



Thanks!!
Regards
Sachin