Ray.Mason
07-04-2012, 10:42 AM
Hi Guys!
I have the below code that is currently excluding weekends in calculated value. However I also want this to exclude holiday days. I have read stuff about networkdays but I can't make any sense of it. Is there anyway I can amend below to exclude UK holiday days?
.Range("I" & lCurrentPhaseLine).Value = Application.WorksheetFunction.WorkDay(.Range("E" & lCurrentPhaseLine).Value, -10)
I have the below code that is currently excluding weekends in calculated value. However I also want this to exclude holiday days. I have read stuff about networkdays but I can't make any sense of it. Is there anyway I can amend below to exclude UK holiday days?
.Range("I" & lCurrentPhaseLine).Value = Application.WorksheetFunction.WorkDay(.Range("E" & lCurrentPhaseLine).Value, -10)