Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
networkdays JK Excel Worksheet Functions 5 May 7th 07 07:52 PM
NETWORKDAYS albertmb Excel Discussion (Misc queries) 3 March 13th 06 09:33 PM
Help on Networkdays Susan Hayes Excel Worksheet Functions 1 September 8th 05 03:34 AM
NETWORKDAYS Help rsteiner1 Excel Worksheet Functions 0 August 10th 05 07:08 PM
Networkdays? Steve Excel Discussion (Misc queries) 6 August 6th 05 01:53 AM


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"