Formula to subtract Month, Week, and Day

Question

I have a list of days, and I am trying to create a formula that will take the days balance and tell me how many months, weeks, and days they are.

example: 28 days = 0 months, 4 weeks, 0 days

it's worth mentioning that months = 31 days, weeks = 7 days, and days are the leftover balance.

here is an example list:

8
30
16
12
12
1
12
6
1
20
6
12
14
3
53
40
19
4
3
2
2
12
14
22
91
6
62
4
17

any help appreciated, thank you

Answer 1

Use:

=INT(A1/31) & " months, " & INT((A1-INT(A1/31)*31)/7) & " weeks, " & A1 - INT(A1/31) * 31 - INT((A1-INT(A1/31)*31)/7)  * 7 & " days"