IF DATE Multiple Conditions

Closed
beejive
Posts
3
Registration date
Wednesday March 26, 2014
Status
Member
Last seen
March 27, 2014
- Mar 26, 2014 at 02:23 AM
I have this code:
=IF(A1<DATE(2015,12,31), "3", IF(A1>DATE(2017,12,31),"2", IF(A1>DATE(2020,12,31), "1")))

I'm trying to categorize those date cutoffs into 3 but apparently, the last category does not go into effect because of the first 2 conditions. So everything after 2020 is still categorize as 2.

How do you categorize these date cutoffs into 3?