Simple Formula, but i can't get it right?

[blimey88]

Good afternoon all,
I have 4 dates across a table, I want to return the smallest date so have used the below, however if that cell is blank I want the cell displaying the date to be blank? This is what I've tried

=SMALL(D2:K2,1,D2,"")

 

[sheetspread]

You need an if statement
Min and small will skip a blank, or do you mean if another cell is blank?

 

[CJS548]

Good afternoon all,
I have 4 dates across a table, I want to return the smallest date so have used the below, however if that cell is blank I want the cell displaying the date to be blank? This is what I've tried

=SMALL(D2:K2,1,D2,"")

=MIN(D2:K2)
(I assumed your dates are in D2:K2)

 

[Fluff]

Maybe
=IF(D2,"","",MIN(D2:K2))

 

[blimey88]

Maybe
=IF(D2,"","",MIN(D2:K2))

when typing this it states that I've entered to many arguments?

 

[blimey88]

=MIN(D2:K2)
(I assumed your dates are in D2:K2)

Hi I have dates in D2,F2,H2 and J2

 

[Dan5977]

=IF(D2="","",MIN(D2:K2))

 

[Fluff]

when typing this it states that I've entered to many arguments?

Oops, it should be
=IF(D2="","",MIN(D2:K2))

 

[blimey88]

Oops, it should be
=IF(D2="","",MIN(D2:K2))

This is marvelous! Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback