I have this long formula with repeating expressions. Can I save an expression as a variable and use it to shorten the formula?
=(E2-(SUMPRODUCT(WEEKDAY(G2:OFFSET(G$33,$F$37,0))=1)+SUMPRODUCT(WEEKDAY(G2:OFFSET(G$33,$F$37,0))=5)))
This expression repeats twice.
WEEKDAY(G2:OFFSET(G$33,$F$37,0))