Excel Formula Help

[happy_2008]

Hi All, can someone help me with a excel formula? I have a spreadsheet that lists some data by maturity date and I need to list the days into certain buckets based on a certain point of the month. I’ll try to list the example below:


Reporting date is 31/10/2018

The data has a maturity date of 19/11/2018.

So number of days is 19

I want the excel formula to split the data into the actual day buckets:

7 days

2weeks

3weeks

4weeks

5week

6weeks

7weeks

Etc
Any advice would be greatly appreciated

 

[happy_2008]

That did work but my last two buckets are 3m and >=3m which I assume the formula above cannot calculate?

 

[happy_2008]

The last two buckets are:
3m - between 8 weeks and 3months
>3m - greater than 3 months.

Will the above formula work for this? If so how would it be written?