Hi ,
I want a if formula for the below

Where in I have to classify the maturity dates as below.

If a date is less than 2 weeks from today then it should reflect as BUCKET C
If a date is more than 2 weeks from today and less than 1 month then it should reflect BUCKET D
If a date is more than 1 month and less than 3 months then it should reflect as BUCKET E
If a date is more than 3month and less than 6months then it should reflect as BUCKET F
If a date is more than 6month and less than 1year then it should reflect as BUCKET G
If a date is more than 1year and less than 2yearsthen it should reflect as BUCKET H
If a date is more than 2years and less than 5years then it should reflect as BUCKET I
If a date is more than 5years then it should reflect as BUCKET J