#### kumara_faith

##### Well-known Member

- Joined
- Aug 19, 2006

- Messages
- 611

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.