Hi,
I have 2 columns of dates
E and J. At E there is always a date, at J there can be a date or it can also be blank.
I want to say that if a date is <= at any date in E and if a date is <= J or blank, then show as Active, if not Inactive
I came up with this statement
=IF(and(E2 <=...