Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NETWORKDAYS
I am using the NETWORKDAYS function to generate statistics for a report. The
problem I am having is that I have a requirement to turn around an activity within one day from receipt of certain information - for example, if I receive the information on Monday, I must turn around the response by Tuesday. However, the function would calculate that as 2 net work days. If I turn it around the same day, it calculates 1 net work day, even though my statistic considers that less than one day. Is there anyway to modify the functions so that same day activity = 0 net work days, next day activity = 1 net work day, etc? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
networkdays | Excel Worksheet Functions | |||
NETWORKDAYS | Excel Discussion (Misc queries) | |||
Help on Networkdays | Excel Worksheet Functions | |||
NETWORKDAYS Help | Excel Worksheet Functions | |||
Networkdays? | Excel Discussion (Misc queries) |