Forum Discussion

Copper Contributor

Oct 28, 2021

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...

Date Check.xlsx9 KB

Formulas and Functions

HansVogelaar
Oct 28, 2021
Rushdi Eskarous

In G2:

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

Fill down.

HansVogelaar

MVP

Oct 28, 2021

Rushdi Eskarous

In G2:

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

Fill down.

Rushdi Eskarous
Copper Contributor
Oct 29, 2021
HansVogelaar
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!
Date Check_with Project.xlsx9 KB
- HansVogelaar
  MVP
  Oct 29, 2021
  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.
  Date Check_with Project.xlsx10 KB
  - Rushdi Eskarous
    Copper Contributor
    Oct 30, 2021
    It worked. Thank you very much!
Rushdi Eskarous
Copper Contributor
Oct 28, 2021
That worked! Thank you so much!!!