I have the following formula and I want to add to it:
=IFERROR(IF(AND(P3="N",vlookup(C3,data!$A$3:$J$16,8,false)>0),(D3-vlookup(C3,data!$A$3:$M$16,8,false)),""),"")
I want all that functionality to stay the same if P3 is a N, but I want to add that if P3 = "Y" then it will return one day later the date in Q3 (So if Q3 was 3/4/2021, it will return 3/5/2021) instead.
Can someone help?
=IFERROR(IF(AND(P3="N",vlookup(C3,data!$A$3:$J$16,8,false)>0),(D3-vlookup(C3,data!$A$3:$M$16,8,false)),""),"")
I want all that functionality to stay the same if P3 is a N, but I want to add that if P3 = "Y" then it will return one day later the date in Q3 (So if Q3 was 3/4/2021, it will return 3/5/2021) instead.
Can someone help?