Diff in business days

[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.

 

[Ron Rosenfeld]

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.

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

 

[Bob Phillips]

Try

=NETWORKDAYS(A2,B2)