I have two columns with a bunch of dates But only the first column also has blanks in them. I cant seem to get the formula right that ignores the banks and to have it return the correct value.
First condition: is that the first i am looking for a date that to be before 12-1-2020
Second Condition: Date in the second column must be after 1-1-2021
Current Formula that i have been working with:
=IF(ISBLANK([@[Column 1]]),IF(AND([@Column 2]>=DATE(2021,1,1), [@[Column 1]] <= DATE(2020,12,1)),"Yes","No"))
First condition: is that the first i am looking for a date that to be before 12-1-2020
Second Condition: Date in the second column must be after 1-1-2021
Current Formula that i have been working with:
=IF(ISBLANK([@[Column 1]]),IF(AND([@Column 2]>=DATE(2021,1,1), [@[Column 1]] <= DATE(2020,12,1)),"Yes","No"))
Column 1 | Column 2 |
---|---|
6/1/2020 | 5/20/2022 |
4/25/2020 | |
4/1/2020 | |
12/20/2019 | 6/8/2022 |
3/5/2021 | 9/7/2020 |