IF DATE Multiple conditions
Solved/Closed
beejive
Posts
2
Registration date
Wednesday March 26, 2014
Status
Member
Last seen
March 27, 2014
-
Mar 26, 2014 at 10:25 AM
beejive Posts 2 Registration date Wednesday March 26, 2014 Status Member Last seen March 27, 2014 - Mar 27, 2014 at 12:07 AM
beejive Posts 2 Registration date Wednesday March 26, 2014 Status Member Last seen March 27, 2014 - Mar 27, 2014 at 12:07 AM
Related:
- IF DATE Multiple conditions
- How to lasso multiple objects in photoshop - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- How to rotate multiple pictures at once windows 10 - Guide
- How to open multiple media player windows - Guide
1 response
xpcman
Posts
19528
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,824
Mar 26, 2014 at 08:15 PM
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