Kyle_BWCopper ContributorApr 04, 2019formula help I'm looking for assistance. I'm looking for a formula to break days down into three categories, 4 week periods, 1 week periods, and leftover single days. example, 37 days equals 1-4 week, 1 single ...Show More
Detlef_LewinSilver ContributorApr 04, 2019Kyle_BW A3=37C2=28C3=7C4=1In C3 and copy to the right:=QUOTIENT($A3-SUMPRODUCT($B2:B2*$B3:B3),C2)
