Networkdays Result

[kumara_faith]

Hi,

I have the following table:

Excel Workbook
	B	C	D	E	F
2	M1	M2	M3	*	Desired Result
3	07/19/10	07/25/10	07/25/10	*	5
4	06/27/10	07/01/10	07/02/10	*	4
5	06/28/10	*	07/05/10	*	5
6	07/13/10	07/21/10	07/20/10	*	5
Sheet1

I need to build a formula in column F for the following criteria:

1) If M2 is same as M3, then use networkdays to calculate the difference of days from M1 to M3. ( M1 is the start date and M3 is the end date)
2) If M2 is less than M3, then deduct 1 day from the result of networkdays from M1 to M3.( M1 is the start date and M3 is the end date)
3) If M2 is empty, then use networkdays to calculate the difference of days from M1 to M3. ( M1 is the start date and M3 is the end date)
4) If M2 is more than M3, then use networkdays to calculate the difference of days from M1 to M3. ( M1 is the start date and M3 is the end date)

The desired result is stated in column F.

Appreciate assistance.

 

[kumara_faith]

bump.

 

[prabby25101981]

Considering that the outcome of condition 1, 2, and 4 is the same, here's the formula -

=IF(OR(B3>=C3,ISBLANK(B3)),NETWORKDAYS(A3,C3),NETWORKDAYS(A3,C3)-1)

Does this help ?

 

[barry houdini]

Try

=NETWORKDAYS(B3,D3)-(C3< D3)*(C3<><D3)*(C3<>"")

 

[kumara_faith]

barry / prabby,

Thank you both for the suggested solutions. Both worked !

Appreciate your valuable time, effort and patience !