View Single Post
  #7   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

Great! Thanks for all of your help.



Ron Rosenfeld wrote:
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

[quoted text clipped - 5 lines]
negative days or holidays being subtracted twice or something . . . so long
as start date=end date . .


Your result should be consistent if you always subtract 1.
--ron


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