Nested If/Or Formula

[Domroy]

Quickie help, please...

I have a formula that calculates work days from two dates. The dates are in F and G. I've discovered that there are instances in the data where one cell has been left blank. I built a formula for if G is blank, then subtract F from itself (so it's a wash), and give me work days. Formula is here:

=IF(ISBLANK(G2),NETWORKDAYS(F2,F2,$AN$2:$AN$19),NETWORKDAYS(F2,G2,$AN$2:$AN$19))

My holidays are obviously in AN2:AN19.

But now I need to add that if F2 is blank, use G2 for both dates so it's a wash. I know it's an or formula, but I'm missing something in there. Help?

I need to look to see if EITHER F or G is blank, and then use the non-blank cell both times in the calculation. Make sense?

Thanks!

Judi

 

[Domroy]

I did it. I used "IFS" - but thank you for what I know would have been an onslaught of excellent answers!