min IF - Bob Philips follow up

[John]

=MAX(INDEX(('data FI'!$T$3:$T$10>=W2)*('data FI'!$T$3:$T$10<=T2)*('data
FI'!$V$3:$V$10),0))

Is the formula that works for finding the max value between two dates...
change Max ti Min and I return 0. Any help is appreciated

 

[Teethless mama]

=MIN(IF(('data FI'!$T$3:$T$10>=W2)*('data FI'!$T$3:$T$10<=T2),'data
FI'!$V$3:$V$10))

ctrl+shift+enter, not just enter

 

[John]

Thanks Teethless... nice name

=MIN(IF(('data FI'!$T$3:$T$10>=W2)*('data FI'!$T$3:$T$10<=T2),'data
FI'!$V$3:$V$10))

ctrl+shift+enter, not just enter