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