Thread: NETWORKDAYS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve 51 Steve 51 is offline
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?