SOLVED

# Nested If Checking date

Occasional Contributor

# 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
best response confirmed by allyreckerman (Microsoft)
Solution

# Re: Nested If Checking date

In G2:

=IF(AND(MAX(D2,E2)>=\$A\$2,MAX(D2,E2)<=\$B\$2),"Pass","Check")

Fill down.

# Re: Nested If Checking date

That worked! Thank you so much!!!

# Re: Nested If Checking date

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!

# Re: Nested If Checking date

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.

# Re: Nested If Checking date

It worked. Thank you very much!