SOLVED

# Find Minimum Date in 5 Different dates

Copper Contributor

# 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
5 Replies

# Re: Find Minimum Date in 5 Different dates

MIN() works in any area.

# Re: Find Minimum Date in 5 Different dates

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.
best response confirmed by Sridhar0311 (Copper Contributor)
Solution

# Re: Find Minimum Date in 5 Different dates

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

# Re: Find Minimum Date in 5 Different dates

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

1 best response

Accepted Solutions
best response confirmed by Sridhar0311 (Copper Contributor)
Solution

# Re: Find Minimum Date in 5 Different dates

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