Working Days Calculation w/a Twist

[BrandykinsGamer]

Hi There -

I need a working day calculation - but with a twist.
Here is my example:

A1 = 5/17/19 B1 = 8/1/19 C1 = _________

Part A: I need day #1 to be the first working day after 5/18/19. And then I need the last working day to be the day of B1. And I need to exclude a list of holidays that I have in another column (D1:D9).

Part B: Now.... another twist If there is not a date in either A1, B1, or both ---> I need C1 to remain blank. I only want C1 to calculate if there are dates in both A1 and B1.

I seemed to get Part A to work by using =NETWORKDAYS(A1,B1,D1:D9)+1
But as you can see, I had to add +1 on the end to make sure it counted the date in B1.


HELP!!!!

 

[DRSteele]

Welcome to the forum.

Unless I'm missing something and assuming your NETWORKDAYS part is okay, then this should do it: =IF(A1*B1,NETWORKDAYS(A1,B1,D1:D9)+1,"")