Provide 3 different results based upon date differences

[InterstateRentals]

One more problem that we cannot get figured out ... Example file is attached.


We have a table with dates A7:A16. We want to compare this list of dates to a date that we input in A1.


Three different results that we want ...

Case 1: ($A$1-$A7)<=15, then $B7="GOOD"

Case 2: 15<($A$1-$A7)<30, then $B7="CALL"

Case 3: ($A$1-$A7)>30, then $B7="CALL!!!"


The results that we expect to get in Column B are written in Column E.

Thank you!