View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Why Networkdays returns 1

Jay,

That's how networkdays works.

If you are due to work 2/4/2009 and do so finishing on 2/4/2009 I bet you
would want paying for 1 days work.

Mike

"Jay" wrote:

Hi,

I am using Networkdays to calculate the difference between two dates. But if
the dates are the same, it returns 1, not 0. I have a workaround, but I am
curious why subtracting two serial numbers that are the same produces 1 not 0.

Thanks,

Jay