Diff in business days

  • Thread starter Thread starter JoeL
  • Start date Start date
J

JoeL

I'm trying to calculate the difference in days between two dates, excluding
the weekends. I've tried some of the suggestions on the discussion boards,
but usually end up with an error or they're not working for me.

Let's assume the dates are in column A and B, with column B being the later
date.

Please help and also let me know how the fields should be formatted.

Thank you in advance.
 
I'm trying to calculate the difference in days between two dates, excluding
the weekends. I've tried some of the suggestions on the discussion boards,
but usually end up with an error or they're not working for me.

Let's assume the dates are in column A and B, with column B being the later
date.

Please help and also let me know how the fields should be formatted.

Thank you in advance.
Click to expand...

The usual recommendation would be to use the NETWORKDAYS function. Help
explains it pretty well. The format of the cell which contains the formula
should be either General, or Number.

Did you try that?
What happened when you did? In other words, what sort of "error" and what
specifically do you mean by "not working for me".

--ron
 
Back
Top