Cell Formulas | ||
---|---|---|
Range | Formula | |
A4 | A4 | =A2-A1+1 |
B4 | B4 | =INT((WEEKDAY($A$1- 1)-$A$1+$A2)/7) |
C4 | C4 | =INT((WEEKDAY($A$1- 2)-$A$1+$A2)/7) |
D4 | D4 | =NETWORKDAYS(A1,A2) |
=INT((WEEKDAY($B$17- 2)-$B$17+$F17)/7)
=INT((WEEKDAY($B$17- 1)-$B$17+$F17)/7)
=INT((WEEKDAY($A$1- 1)-$A$1+$A2)/7)