Date difference taking into account weekends.
 

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 :)

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" wrote in message
...
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 :)

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" wrote in message
...
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 :)

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" wrote in message
...
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 :)