Hello,

I have a sheet with 10 columns across of dates, the dates are when we
received certain documents. There is one final column that has the date by
which all of the documents should have been received.

How do I have excel compare all 10 dates to the 1 final date, and have it
make note if any of the dates (in the set of 10) are greater than the 1 final
date?

I do not want it to produce late/not late for each individual document
(which I am able to do easily), as the pack of documents is considered
invalid if even just one document was late, so I need it to look at all dates
at once and just produce a "this document pack is compliant" or "this
document pack is not compliant".

I had attempted using IF (eg if A2:F2G2,"non compliant", "compliant") type
thing, but that produces a #VALUE for me, so I have to changesomething, I am
just not entirely sure what. Thanks!