Is the title remotely possible to accomplish?
I'll begin where I reside currently... my formula below is my current iferror,index,match array that is working as intended.
=IFERROR(INDEX(ZRSCH!Y:Y,MATCH(1,(A2=ZRSCH!C:C)*(B2=ZRSCH!D:D),0)),"Keep Current Date")
The above is currently returning a date where applicable and where a date is not, it will say Keep Current Date.
I need to add a criteria requirement for the Date that is being returned, criteria being two dates I have already provided elsewhere of a window of 7 workdays, forward and backwards. So for the example: C1 = 03/08/2019 and D1 = 03/28/2019 if we ran this today.
My initial thought is another column, but I would truly like to avoid this. Basically, if the return falls between C1 and D1 OR it cannot be indexed, I want it to "Keep Current Date", Otherwise, it is to return the date it found.
Bookmarks