working day calculator

W

whatzzup

Good day, i am looking for a spreadsheet that can help me calculate UK
working day between specific dates?

Would be most greatfull...
Thanks
 
M

Mike H

You can do it with a formula

=NETWORKDAYS(A1,B1,D1:D8)

Where
A1= Period start date
B1 = Period end date
D1:D8 is a list of UK publich holidays

Mike
 
D

Dave Peterson

Ps. If the OP is using xl2003 or below and gets a #name! error, the OP will
have to install the analysis toolpak.

Tools|Addins
 
Top