turn around time

W

Windy

How do I find turn around time using weekdays only? How can I allow for
holidays that fall during the week?
 
P

Pete_UK

This is part of the Analysis Toolpak add-in, so this needs to be
installed for NETWORKDAYS to work.

Hope this helps.

Pete
 
W

Windy

Thanks, the add-in worked, but it seems to be adding an extra day. ie:
Friday to Friday should be 0 turn around and i'm getting 1. friday to monday
should be 1 day turn around and I'm getting 2. Can you give me additional
help, please?
 
P

Pete_UK

Just subtract 1 from your formula. Some date calculations include the
start and/or end dates, so -1 in the formula is quite common.

Hope this helps.

Pete
 

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

Similar Threads

2016 Project, adding a workday to custom field 0
Default IF Date Is between 2 Dates then output additional column 1
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Work Budget Salary vs Real Time Salary 0
Office365 Family + TXT or MX Domain 0
Changing login email address for office 365 admin (O365 Busines) 0
How to implement two shifts per day with multiple teams 0
Problems created by Recent updates to Outlook 365 0

Top