# calculate business days(where there is 6 days a week)

1. ## calculate business days(where there is 6 days a week)

Hi,
I want to calculate net business days between two dates,I have used networkdays() but its not giving desired result.  Register To Reply

2. ## Re: calculate business days(where there is 6 days a week)

Hi

You need to tell us what results you expect and why.

Regards  Register To Reply

3. ## Re: calculate business days(where there is 6 days a week)

Which 6 days do you want to count? Assuming all days except Sundays you can use this formula in row 2 copied down

=SUM(INT((WEEKDAY(C2-{2,3,4,5,6,7})+N2-C2)/7))

If you have Excel 2010 you can use NETWORKDAYS.INTL function, i.e.

=NETWORKDAYS.INTL(C2,N2,11)  Register To Reply

4. ## Re: calculate business days(where there is 6 days a week)

I need to calculate difference between column N and column C,and the formula would able to identify if there is any sunday in between the dates and exclude that date.  Register To Reply

5. ## Re: calculate business days(where there is 6 days a week)

Thanks for the formula,but if you look at the first row,although by normal substraction the difference comes 1 days,but using your formula its coming 2 days,we need to rectify it.  Register To Reply

6. ## Re: calculate business days(where there is 6 days a week)

The formula I suggested works like NETWORKDAYS in that it include both start and end date, e.g. like NETWORKDAYS it will count 2 for a date range starting on a Tuesday and ending the next day (because it counts both the Tuesday and the Wednesday).

If you want the count to be 1 in that instance then you can just subtract 1, i.e. use this formula.

=SUM(INT((WEEKDAY(C2-{2,3,4,5,6,7})+N2-C2)/7))-1

....but if the start or end date of the range might be a Sunday then that might not give you the results you expect. What result do you expect if start date is Sunday and end date the following Tuesday....or Friday to Sunday?  Register To Reply

7. ## Re: calculate business days(where there is 6 days a week)

The start date cannot be a sunday,but the end date can be a sunday  Register To Reply

8. ## Re: calculate business days(where there is 6 days a week)

OK, then by your definition Friday to Saturday =1, Friday to Monday = 2, is that right? so what should Friday to Sunday be? still 1? If so then the last formula I suggested should work for you, i.e.

=SUM(INT((WEEKDAY(C2-{2,3,4,5,6,7})+N2-C2)/7))-1  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1