Copy ID Data based on converting date series into start date and end date

[decent_boy]

Hi,
I have data sheet with Numbers in col A , ID in Col B and Dates in Col C I Just need a macro to copy each Number and convert its dated into start date and end date. I am attached here images of Data Sheet and Result Sheet.

 

[decent_boy]

I don't see either ID in your data sheet or result sheet. Again, I ask: Why do you have three different start dates and ends dates for 12345? I have spent some time trying to help you. If you cannot post data that reflects all possible variations of Number and ID, then perhaps someone else on the Forum will be able to help you.

You can see ID in data sheet, I have three different dates for 12345 because there is a date sequence breakup if you see in data sheet and i have to calculate actual number of working days against each number

 

[decent_boy]

You can see ID in data sheet, I have three different dates for 12345 because there is a date sequence breakup if you see in data sheet and i have to calculate actual number of working days against each number

mumps,
I hope that you have understood now what i said in above

 

[decent_boy]

Any other Expert on this forum can you please help to resolve it

 

[decent_boy]

Any other Expert on this forum can you please help to resolve it

I hope that someone else would reply on it if it can be possible or not

 

[decent_boy]

Can Someone please reply on it ?