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 area.

Any insights are highly appreciated. Thanks.

Eg:

	Date1	Date2	Date3	Date4	Date5	Minimum Date
Project1	30-08-2023	26-08-2023	27-08-2023	28-08-2023	29-08-2023	26-08-2023

Formulas and Functions

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 ))))

Detlef_Lewin
Silver Contributor
Aug 25, 2023
Sridhar0311
MIN() works in any area.
- Sridhar0311
  Copper Contributor
  Aug 25, 2023
  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.
  - SergeiBaklan
    MVP
    Aug 25, 2023
    Sridhar0311
    
    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 ))))

Forum Discussion

Find Minimum Date in 5 Different dates

Share

Resources