Finding largest date from 3 different dates

[welchs101]

Hi,

I have 3 arrays which can contain either a "Date" or the text "N/A".

For example lets say i have D1="N/A", E1="N/A" and F1=10/31/15

I want to find the largest date from D1 and E1 and F1. IN the above example the largest date is F1=10/31/15.

Any good ideas on how to do this...........i tried using "application.worksheetfunction.max" but it does not work.

[YasserKhalil]

Try this

Please Login or Register  to view this content.

[Marc L]

Hi !

D1:F1 is not 3 arrays but just 3 cells !

Anyway, MAX Excel function sample with real Date format cell(s) :

Sub Demo()
    T$ = Join$(Filter([IF(ISNUMBER(D1:F1),D1:F1)], False, False), ",")
    If T > "" Then MsgBox CDate(Evaluate("MAX(" & T & ")"))
End Sub 

Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

[Marc L]

Direct way :

Sub Demo2()
    MsgBox CDate([MAX(IF(ISNUMBER(D1:F1),D1:F1,0))])
End Sub 

Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

[Marc L]

Duplicate …

[Marc L]

Duplicate …

[Marc L]

Duplicate …

[welchs101]

what is "Duplicate"

[Marc L]

Duplicate post when I tried to edit original one …