W
Windy
How do I find turn around time using weekdays only? How can I allow for
holidays that fall during the week?
holidays that fall during the week?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
Windy
I tried the =NETWORKDAYS(A2,C2) and got #NAME?
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
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?
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
start and/or end dates, so -1 in the formula is quite common.
Hope this helps.
Pete