Copy a specific range to another sheet adding all the workdays for a specific time period

Hello

I have a small range that i need to copy to another sheet for each working day of a time period(01/01/2014-30/04/2014) excluding weekends and holidays, adding the date in the first column of the new sheet.

Can you help me on this?

Thanks in advance for any assistance.

Hello

Thank you very much for the code. I have 2 issues

1) Does not copy correct the second time

2) Copy code,inCLUDES THE HOLIDAYS(Also if you notice i have a named range calling Holidays which is not inclunded in the code)

Can you do anything for this?

Also i just noticed that code does not exclude weekends too!

Thank you again but does not works for me even this time.I get ALL the dates(inclunding weekends & Holidays and also in column E i get 08:00 As result for all the names except name A).

Also. Do you have any idea for how can we use the named range(Holidays) in the code? I asked this because if we use the code for many months-years then we have to type 20-30 holidays inside the code.

I upload again the sample workbook with the results that i get.

Can you pls upload my sample workbook with the correct results that you get when you use your code?

Originally Posted by stnkynts

Here you go. No weekends or listed Holidays came up on sheet 2.

Yes that's it!

But

..and also in column E i get 08:00 As result for all the names except name A).

This problem still exist!

Also

..Also. Do you have any idea for how can we use the named range(Holidays) in the code? I asked this because if we use the code for many months-years then we have to type 20-30 holidays inside the code.

Any idea for this?

Originally Posted by stnkynts

Already did. Look at the code, it is different.

Sorry i didn't noticed this. You are right!

I am still curious what you were doing as to why it wasn't working for you but was working for me.

Me too!!

Thank you for your solution and of course for your patient. Everything works fine now!