I wish to run a macro that will roll forward yesterdays workday into today's current work day, whilst also taking into account the bank holidays on the right.

The cell reference I need updating is I8.

The cell formula in I7 is =NETWORKDAYS(I2,I4,$K$3:$K$10)

I'm really green at VBA so any help would be greatly appreciated.

Name:  Capture 1.JPG
Views: 70
Size:  29.5 KB

Thank you.