SOLVED

Nested If Checking date

Copper Contributor

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

@Rushdi Eskarous 

In G2:

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

Fill down.

That worked! Thank you so much!!!

@Hans Vogelaar 

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!

@Rushdi Eskarous 

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!
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@Rushdi Eskarous 

In G2:

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

Fill down.

View solution in original post