Forum Discussion

Rushdi Eskarous's avatar
Rushdi Eskarous
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...
Formulas and Functions
  • HansVogelaar's avatar
    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's avatar
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's avatar
Rushdi Eskarous
Copper Contributor
Oct 28, 2021
That worked! Thank you so much!!!

Resources