Working days for a date range avoid week ends

[system]

Hi Guru’s,

Please can any one help me, how to calculate the working days for a given date range( avoiding weekends - Saturday & Sunday)
For Example:
Ship date >= Startdate ; Ship date < Enddate+1

If we are considering start date- 12/01/2008 and End date - 12/10/2008
Total days =10
weekends days = 2
Total Working days = 8.

I have searched BOB forum but i couldnt get much help.

Thanks,
Kumar_08

---

kumar_08 (BOB member since 2008-11-09)

[system]

Hi,

Same question was asked yesterday here:

120×120 10.4 KB

Hi, I have a little problem how to throw out weekends from time created between two dates. I’m using 2 dates objects ([start time] , [end time]). I want to create condition that check if is weekend between start and end date total time will be reduced by (saturday and sunday =172800 seconds) I used this formula to change date for time in seconds: =DaysBetween([Start Time];[End Time])*86400 + (ToNumber(FormatDate([End Time];"HH"))*3600 + ToNumber(Left(FormatDate([End Time];"mm:ss");2))*60+ To…

---

Marek Chladny (BOB member since 2003-11-27)