Prev: Need a shorter # of Levels
Next: Time Values As Numbers
From: JoeL on 3 May 2010 16:08
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.
From: Ron Rosenfeld on 3 May 2010 16:18
On Mon, 3 May 2010 13:08:08 -0700, JoeL <JoeL(a)discussions.microsoft.com> wrote:

>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
From: Bob Phillips on 3 May 2010 16:21

Try

=NETWORKDAYS(A2,B2)


--

HTH

Bob

"JoeL" <JoeL(a)discussions.microsoft.com> wrote in message
news:77E1E2D8-ED96-4ADF-90F5-B111A7CB4649(a)microsoft.com...
> 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.


 | 
Pages: 1
Prev: Need a shorter # of Levels
Next: Time Values As Numbers