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) 
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies