-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
working week
-
A
dates between range including start and finish
I've tried using =NETWORKDAYS and it does work, but it excludes the start and finish dates. Is there a method that will count weekdays in a range while including and the start and end in that range? example: Start date: July 8th, 2020 End date: July 15th, 2020 NETWORKDAYS: 4 Desired count: 6- Afro_Cookie
- Thread
- date range networkdays weekdays working week
- Replies: 5
- Forum: Excel Questions
-
T
Excel Grade of Service / SLA formulas
Apologies I'm very very new to excel formulas etc. so please be patient with me </SPAN></SPAN>:) I have a spreadsheet which contains raw message stats and need to be able to work out if each message received is within 1 hour SLA however I'm not sure the best way to do this or easiest. In...- totalmat
- Thread
- calculation formula working hours working week
- Replies: 8
- Forum: Excel Questions
-
F
Working out business hours from/to specific dates/times
Hello! I am hoping someone can assist with a template they just happen to have kicking around... I need to know the specific business hours from the first date/time to the second date/time, based on: a 9 hour (8-5pm) day a 5 day working week (Mon-Fri), with BC, Canada holiday dates factored...- flejbeetle
- Thread
- business days business hours holidays weekends working week
- Replies: 0
- Forum: Excel Questions
