Formula to display workday days with condition

Hello,

7/2/2014 16:18

7/4/2014 10:19


I want formula which would show netwrokday ( Exclude Saturday and Sunday ).

I above date should give me answer as 2 Days. How to do that?

Thanks,
Shiva

7/2/2014 = Wed
7/3/2014 = Thu
7/4/2014 = Fri

NETWORKDAYS = 3

So, which date do you want to not count?

This might also work for you, depending on which workdays you want to exclude...

	B	C	D	E
1	7/2/2014 16:18	3	6	8
2	7/3/2014 16:18	4
3	7/4/2014 16:18	5
4	7/5/2014 16:18	6
5	7/6/2014 16:18	7
6	7/7/2014 16:18	1
7	7/8/2014 16:18	2
8	7/9/2014 16:18	3
9	7/10/2014 16:18	4
10	7/11/2014 16:18	5

C1=WEEKDAY(B1,2) (not really needed and not used, I just used it to show the week day number)
D1=SUMPRODUCT(--(WEEKDAY($B$1:$B$10,2)<6)*--(WEEKDAY($B$1:$B$10,2)<>4)) exclude Thursdays
E1=SUMPRODUCT(--(WEEKDAY($B$1:$B$10,2)<6)) count all weekdays (Tony's suggestion for this is much better)

Tony/Ford,

I do not want exclude date there..

Start time is 7/2/2014 4:18 PM. Now request need to be closed within 2 business days which means, request should be closed before 07/04/2014 at 11.59PM
If look at the time differenc between these two date, it is around 2 days and 7 hours. But I need some formula which would round the time to 2 days only. If request has been closed at 07/05/2014 at 12.01 AM, then answer should be 3 days.

7/2/2014 16:18
7/4/2014 10:19
Answer to this is : 2 days

7/2/2014 16:18
7/5/2014 23:19
Answer to this is : 3 days

7/2/2014 16:18
7/6/2014 00:19
Answer to this is : 4 days.


Hope this helps.

Please advice,

Thanks,
Shiva

Hello Shiva,

According to your first post you want to exclude Saturday and Sunday.......but if those examples in your last post are right you are including Saturday and Sunday......which is correct?

If those latter example are right you can use this formula

=INT(B1)-INT(A1)