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?

IF DATE Multiple Conditions
If cell contains text then return value multiple conditions ✓ - Forum - Excel
Excel vba conditional formatting formula multiple conditions ✓ - Forum - Excel
Using if function in excel with multiple conditions - Guide
How to insert multiple conditions in a formula? ✓ - Forum - Excel
IF DATE Multiple conditions ✓ - Forum - Excel

Subscribe To Our Newsletter!