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