Evaluate Dates across multiple columns and conditions

[BillTony]

I have 4 columns "usually" containing dates that I must evaluate using VBA.

Column A is the Driver and if is blank the remaining conditions are irrelevant.

So given a valid date is present in column A - columns B, C or D could potentially be blank.

If there IS a date in columns B, C or D - the date found in column A must be within 90 days PRIOR to any of those dates.

As always - any insight is greatly appreciated!

 

[shknbk2]

Try this:

=IF(NOT(ISBLANK(A1)),OR(AND(DAYS(B1,A1)<=90,DAYS(B1,A1)>0),AND(DAYS(C1,A1)<=90,DAYS(C1,A1)>0),AND(DAYS(D1,A1)<=90,DAYS(D1,A1)>0)),"")

 

[BillTony]

Thanks a bunch - this works great!

 

[BillTony]

Could this be adjusted to display a "Pass" or "Fail" instead of True/False?

 

[shknbk2]

Sure, by adding another nested IF:

=IF(NOT(ISBLANK(A1)),IF(OR(AND(DAYS(B1,A1)<=90,DAYS(B1,A1)>0),AND(DAYS(C1,A1)<=90,DAYS(C1,A1)>0),AND(DAYS(D1,A1)<=90,DAYS(D1,A1)>0)),"Pass","Fail"),"")

 

[BillTony]

Awesome - thanks!