Calculate number of days between 2 dates & then assign a number based on the answer

Can someone please help me create a spreadsheet with what I think will be a very simple formula?

If date in B2 - date in A2 is 1 or less days, put a 1 in cell C2.
If date in B2 - date in A2 is 7 or less days but more than 1, put a 2 in cell C2.
If date in B2 - date in A2 is 30 or less days but more than 7, put a 3 in cell C2.
If date in B2 - date in A2 is 90 or less days but more than 30, put a 4 in cell C2.
If date in B2 - date in A2 is 91 days or more, put a 5 in cell C2.

OR

Another, maybe simpler, way of saying it is:

If date in B2 - date in A2 is 1 or less days, put a 1 in cell C2.
If date in B2 - date in A2 is 2-7 days, put a 2 in cell C2.
If date in B2 - date in A2 is 8-30 days, put a 3 in cell C2.
If date in B2 - date in A2 is 31-90 days, put a 4 in cell C2.
If date in B2 - date in A2 is 91 days or more, put a 5 in cell C2.

Thank you!

Maybe this...

=IFERROR(MATCH(B2-A2,{0,2,8,31,91}),"")

Like this...

=TODAY()


We used to party in Youngstown back in the 80's!

I downloaded the file and it shows the correct result of 3.

B2-A2 = 21

21 falls into category 3:

If date in B2 - date in A2 is 1 or less days, put a 1 in cell C2.
If date in B2 - date in A2 is 2-7 days, put a 2 in cell C2.
If date in B2 - date in A2 is 8-30 days, put a 3 in cell C2.
If date in B2 - date in A2 is 31-90 days, put a 4 in cell C2.
If date in B2 - date in A2 is 91 days or more, put a 5 in cell C2

OK, I see the problem but, once again, when I open the file I get the correct result of 3.

I wonder why I get the result but you don't?

The date in B2 is a TEXT value. It may look like a date but it's actually just a TEXT string that looks like a date. You can tell this because Excel aligns text to the left and numbers (dates) to the right. Widen column B and you'll see it more clearly. Notice how A2 is aligned right while B2 is aligned left.

The cell is formatted as Date but that really doesn't matter. Do this:

Select cell B2
Double click
Hit Enter

The formula should now return the correct result.

OK, here's the file with the formula returning the correct result.

Priorities(1).xlsx