Forum Discussion
Solved
Nested If Checking date
Hi, I have a question and I don't know if you guys can help with or not. I have 2 columns that can have dates to check against a date range. I need a formula in G2 to check D2 and E2 and whenever...
Hi, What if I need to do the same thing but for more than one project and each project has its own date range (attached here)
Thank you!
See if this does what you want:
=IF(AND(MAX(G2:H2)>=VLOOKUP(I2,$A$2:$C$3,2,FALSE),MAX(G2:H2)<=VLOOKUP(I2,$A$2:$C$3,3,FALSE)),"Pass","Check")
See the attached version.
- It worked. Thank you very much!