min function return earliest date from 2 other functions

[sarah1991]

Hi I have a function called getdates and getdates2 basicly they are you same function but folder Dir is different
I want to get earliest date using min function
Like =min (getdates, getdates2) will work fine if there is text file with specific date if no date found then it will return 0
When I check each function individualy one return 0 and the other a date
So how can I use min function and ignore the function that return 0 ?

Excel 2010 win 7

 

[sarah1991]

I'd guess...

=IF(COUNT(1/FSGETDATES($B4,C$2),1/FSGetDates2($B4,C$2))=2,MIN(FSGETDATES($B4,C$2),FSGetDates2($B4,C$2)),MAX(FSGETDATES($B4,C$2),FSGetDates2($B4,C$2)))

thanks you very much mr.aladin .

 

[Aladin Akyurek]

thanks you very much mr.aladin .

Glad I could help...