Date difference taking into account weekends.

[annonymous]

Hello,
Is there any way to calculate the difference between two dates that take
into account weekends? If i have a start date and an end date, i dont want
the difference between them to include any weekends between them.
Thanks a million

[JulieD]

Hi

one option is to use the NETWORKDAYS function which is included in the
analysis toolpak (tools / add-ins / analysis toolpak)
check out help for details

Cheers
JulieD

"annonymous" <annonymous@discussions.microsoft.com> wrote in message
news:8FFC1690-424E-4DE4-BC58-371EDFC2A78A@microsoft.com...
> Hello,
> Is there any way to calculate the difference between two dates that take
> into account weekends? If i have a start date and an end date, i dont want
> the difference between them to include any weekends between them.
> Thanks a million

[Bob Phillips]

Take a look at the NETWORKDAYS function, which is part of the Analysis
Toolpak add-in (that is you must have it installed). It ignores weekends,
and can ignore holidays if you want.

It takes the form

=NETWORK(start_date,end_date,holidays)
holidays can be omitted.


--

HTH

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


"annonymous" <annonymous@discussions.microsoft.com> wrote in message
news:8FFC1690-424E-4DE4-BC58-371EDFC2A78A@microsoft.com...
> Hello,
> Is there any way to calculate the difference between two dates that take
> into account weekends? If i have a start date and an end date, i dont want
> the difference between them to include any weekends between them.
> Thanks a million

[Daniel.M]

Hi,

If you have holidays, use NETWORKDAYS()

If you don't have holidays:
=SUM(INT((EndDt-WEEKDAY(EndDt-{1;2;3;4;5})-StartDt+8)/7))

Regards,

Daniel M.

"annonymous" <annonymous@discussions.microsoft.com> wrote in message
news:8FFC1690-424E-4DE4-BC58-371EDFC2A78A@microsoft.com...
> Hello,
> Is there any way to calculate the difference between two dates that take
> into account weekends? If i have a start date and an end date, i dont want
> the difference between them to include any weekends between them.
> Thanks a million