Home

formula help

Kyle_BW
Occasional Visitor

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 week, and 2 single days.

Any help would be appreciated. thanks. 

1 Reply

@Kyle_BW 

A3=37
C2=28
C3=7
C4=1

In C3 and copy to the right:

=QUOTIENT($A3-SUMPRODUCT($B2:B2*$B3:B3),C2)