ExcelBanter - working day calculator

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - working day calculator (https://www.excelbanter.com/excel-discussion-misc-queries/185086-working-day-calculator.html)

whatzzup

working day calculator

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

Would be most greatfull...
Thanks

Mike H

working day calculator

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

"whatzzup" wrote:

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

Would be most greatfull...
Thanks

Dave Peterson

working day calculator

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

Mike H wrote:

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

"whatzzup" wrote:

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

Would be most greatfull...
Thanks

--

Dave Peterson

All times are GMT +1. The time now is 12:17 AM.