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 a date is found to check it against the date range (beginning and Ending) in A2 and B2 and return "Pass" if the date falls in the range and "Check" if the date is not in the range.
5 Replies
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.
- That worked! Thank you so much!!!
