Forum Discussion
Solved
Find Minimum Date in 5 Different dates
Hi All, Is there any way that we can create a formula using IF funtion to find out the minimum date in 5 Different dates & we cannot use any other funtion. Because i need to use this in different ar...
As variant
=IF( (B2<C2)*(B2<D2)*(B2<E2)*(B2<F2), B2, IF( (C2<B2)*(C2<D2)*(C2<E2)*(C2<F2), C2, IF( (D2<B2)*(D2<C2)*(D2<E2)*(D2<F2), D2, IF( (E2<B2)*(E2<C2)*(E2<D2)*(E2<F2), E2, F2 ))))
i am aware that MIN() works in Excel but i am using a unique application where limited excel formulas will work.
So If the formula available with IF funtion will be helpful in this case.
So If the formula available with IF funtion will be helpful in this case.
As variant
=IF( (B2<C2)*(B2<D2)*(B2<E2)*(B2<F2), B2, IF( (C2<B2)*(C2<D2)*(C2<E2)*(C2<F2), C2, IF( (D2<B2)*(D2<C2)*(D2<E2)*(D2<F2), D2, IF( (E2<B2)*(E2<C2)*(E2<D2)*(E2<F2), E2, F2 ))))- Yes, i got it
Perhaps some other functions work in your app and that could be done easier.