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.
In C3 and copy to the right: