Forum Discussion
If Cell ISBLANK then look at other Cell
So, you have two lesson dates in A6 and A7 (or that could be more, in A8, A9, etc.?). If the latest non-blank lesson date is greater or equal to starting date you display the name, otherwise nothing. Correct?
If so the formula could be
=IF(MAX(A6:A7)>=Sheet1!F8,Sheet1!F6,"")
Hi Martin,
It could be
=IF(AND(A6>Sheet1!F8,OR(A7>Sheet1!F8,ISBLANK(A7))),Sheet1!F6,"")
Hi Sergei, Thanks, that is of great help! I added the equal symbols: =IF(AND(A6>=Sheet1!F8,OR(A7>=Sheet1!F8,ISBLANK(A7))),Sheet1!F6,"")
Now I somehow have 1 minor issue. If the starting date is the same as the date in A7, the name disappears, despite having the >= symbol. Do you know what is happening? Thank you so much for all your help!!
Martin, it shall work
Are you sure A6 is not less than starting date?
For me it isn't working. For the names: Jack starts at 2018-06-12, and the second (Annie) starts at 2018-06-13. However, Annie isn't showing despite me using the exact formula.
Does it work for you because both your dates are the same?
Martin, in your sample A7 (and I guess starting date) are June 13. In A6 you have June 12 which is less than starting date. As I understood your logic
If A6 or A7 is later than Sheet!F8, I want a name to display in the field (imported from Sheet1!F6). However, If A6 is later than the starting date, but A7 is still blank, I still want the name to display.
the name shall be displayed if A6 is not less than starting date (not our case in sample) and A7 is blank or later than starting date.
Or you assume another logic for A6?
