Find Minimum Date in 5 Different dates

[Sridhar0311]

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

[#2]

@Sridhar0311 

MIN() works in any area.

[#3]

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.

[#4 · Accepted solution]

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

[#5]

Yes, i got it

[#6]

@Sridhar0311 

Perhaps some other functions work in your app and that could be done easier.