Hello Excel Gurus!
I am befuddled over an IF/OR function in Column M (M2) of Networkdays where if Column L (L2) has "Closed" as a status Networkdays calculates the difference between J2(start date),K2(end date),HOLIDAYS in M2. But if Column L (L2) has "Open" as a status Networkdays calculates the difference between J2(start date),TODAY(end date),HOLIDAYS. Also, if Column L is marked as "Closed" but there is no date populated in the corresponding end date cell (K), ERROR should be returned to prompt data entry corrections.
<tbody>
</tbody>
I appreciate your time, Thanks!
I am befuddled over an IF/OR function in Column M (M2) of Networkdays where if Column L (L2) has "Closed" as a status Networkdays calculates the difference between J2(start date),K2(end date),HOLIDAYS in M2. But if Column L (L2) has "Open" as a status Networkdays calculates the difference between J2(start date),TODAY(end date),HOLIDAYS. Also, if Column L is marked as "Closed" but there is no date populated in the corresponding end date cell (K), ERROR should be returned to prompt data entry corrections.
J - Start Date | K - End Date | L - Status | M - Bus Days |
10/26/13 | 12/3/13 | Closed | |
11/21/13 | 1/9/14 | Closed | |
1/27/14 | Open | ||
2/21/14 | 3/27/14 | Closed | |
3/20/14 | Closed |
<tbody>
</tbody>
I appreciate your time, Thanks!