View Single Post
  #4   Report Post  
Daniel.M
 
Posts: n/a
Default

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