Skip to Content
Former Member
Dec 19, 2006 at 12:22 PM

No of Working Days and Weekends


Hi All,

I have one requirement.

I have two dates: Start Date and End Date.

If i subtract these two days , i will be getting the no of days between these two dates.

But for my logic , this subtraction should exclude the weekends.

For Example:

If the Start date is: 01.01.2006 and End Date is 08.01.2006, and if i subtract these two days, the difference is: 7 But this includes weekends also.

If we exclude the weekends i.e : 01.01.2006, 07.01.2006 and 08.01.2006 the difference would be 5.

How to go ahead with this logic.

Thanks in Advance.

Abhijith H