Comparing 3 Dates

[cstimart]

Is it possible to confirm that multiple cells/dates are < a specific date in a shorten version than using an If...AND...AND...AND...AND...THEN statement?

 

[VoG]

Is this in a formula or VBA?

 

[cstimart]

Is this in a formula or VBA?

VBA

My Bad

 

[AlphaFrog]

You could use a If-MAX formula...

=IF(MAX(A1:A10) < TODAY(), "All dates are less than today.", "At least 1 date is greater than today")

EDIT: VBA

If Worksheetfunction.Max(Range("A1:A10")) < Date Then
   MsgBox "All dates are less than today."
Else
   MsgBox  "At least 1 date is greater than today"
End If

 

[VoG]

Try like this

If WorksheetFunction.Max(Range("A1:A10")) < Date Then ' they are all less than today