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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies