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

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