Calculating number of days

I have two columns with date filled in. For example one of
the columns has a date of 02/23/05 the second columns has
a date of 03/01/05. What I need is to calculate the
number of day between the two dates minus the weekend
days. Can anyone help me.

Check out the NETWORKDAYS worksheet function in Excel
Help.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I have two columns with date filled in. For example one
of
>the columns has a date of 02/23/05 the second columns
has
>a date of 03/01/05. What I need is to calculate the
>number of day between the two dates minus the weekend
>days. Can anyone help me.
>.
>

Look at NETWORKDAYS, you need to have ATP installed but it comes with
excel/office

=NETWORKDAYS(start,end,holidays)

could look like

=NETWORKDAYS(A1,B1,H2:H10)


--

Regards,

Peo Sjoblom

"Carlos" <anonymous@discussions.microsoft.com> wrote in message
news:1ba201c51e9a$7757d950$a501280a@phx.gbl...
> I have two columns with date filled in. For example one of
> the columns has a date of 02/23/05 the second columns has
> a date of 03/01/05. What I need is to calculate the
> number of day between the two dates minus the weekend
> days. Can anyone help me.

Take a look at the NETWORKDAYS function, which needs the Analysis Toolpak to
be installed.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carlos" <anonymous@discussions.microsoft.com> wrote in message
news:1ba201c51e9a$7757d950$a501280a@phx.gbl...
> I have two columns with date filled in. For example one of
> the columns has a date of 02/23/05 the second columns has
> a date of 03/01/05. What I need is to calculate the
> number of day between the two dates minus the weekend
> days. Can anyone help me.