Oct 28 2021 09:30 AM
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.
Oct 28 2021 10:43 AM
SolutionOct 29 2021 01:24 PM - edited Oct 29 2021 01:25 PM
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!
Oct 29 2021 01:46 PM
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.
Oct 28 2021 10:43 AM
SolutionIn G2:
=IF(AND(MAX(D2,E2)>=$A$2,MAX(D2,E2)<=$B$2),"Pass","Check")
Fill down.