View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
undrline via OfficeKB.com undrline via OfficeKB.com is offline
external usenet poster
 
Posts: 18
Default NetWorkdays Calculation isn't working

My purposes is for turnaround time. If the company received a piece of mail
on Monday, and the reviewer sent their response on Friday, they'd have turned
it around in four business days, as far as our company's compliance with
regulatory mandates are concerned.

The thing is, I think I'd be safe always subtracting a one, right? I can't
think of any case where it would screw up the formula and end up with
negative days or holidays being subtracted twice or something . . . so long
as start date=end date . . .



Ron Rosenfeld wrote:
Thank you for the response.

So, if I understand you correctly, whereas I would count something started
and ended on the same day as 0 workdays, networkdays would count it as 1
workday. So, I should always be subtracting one from networkdays, for my
purposes . . .


Depends on whether you're the employer or the employee <g.

If I started to work on Monday, and quit on Friday, I'd expect to get paid for
five days, not four.
--ron


--
Message posted via http://www.officekb.com