Aug 06 2021 04:51 AM
Aug 06 2021 05:16 AM
Well, let me first commend you on a very complicated formula that works.
Second, let me point you to the newly released LET function, which will enable you to write in a formula only once something like DATEDIF(A3,(B3-((B3-A3)-NETWORKDAYS.INTL(A3,B3,1))) by giving it a name (very similar to naming a range or a cell) and then using that name to represent the calculation it represents, all of this in the same single formula.
I'll work with it too, but thought you might enjoy exploring LET on your own, and you certainly are more familiar than I with the ins and outs of your formula. https://exceljet.net/excel-functions/excel-let-function