IF DATE Multiple conditions
Solved/Closed
beejive
beejive
- Posts
- 3
- Registration date
- Wednesday March 26, 2014
- Status
- Member
- Last seen
- March 27, 2014
beejive
- Posts
- 3
- Registration date
- Wednesday March 26, 2014
- Status
- Member
- Last seen
- March 27, 2014
Related:
- 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
- Find the sum of data that has multiple conditions in Excel ✓ - Forum - Excel
1 reply
xpcman
Mar 26, 2014 at 08:15 PM
- Posts
- 19532
- Registration date
- Wednesday October 8, 2008
- Status
- Contributor
- Last seen
- June 15, 2019
Mar 26, 2014 at 08:15 PM
I suggest you change the order you are checking the dates. 2020, 2017 then 2015.
=IF(A1>DATE(2020,12,31), "1", IF(A1>DATE(2017,12,31),"2", IF(A1<DATE(2015,12,31), "3")))
Any date > 2020 is also > 2017
=IF(A1>DATE(2020,12,31), "1", IF(A1>DATE(2017,12,31),"2", IF(A1<DATE(2015,12,31), "3")))
Any date > 2020 is also > 2017
Mar 27, 2014 at 12:07 AM