working day calculator

  • Thread starter Thread starter whatzzup
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top