Formula Woes

[blimey88]

Good morning all,

I have recently been helped with a formula that I had been struggling with. I have 4 cells that will either contain a date or not, I would like the earliest date displayed in cell L2. As it stands if D2 is empty then so is L2, however if i only have 1 date in 1 of the 4 cells i would like that date displayed in cell L2, please see formula below. So what I need is, if all 4 cells are populate diwth a date show the earliest date, if however there is only one date then populate L2 with that one date? My date cells are D2,F2,H2,J2!

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

 

[jasonb75]

Try

=IFERROR(1/(1/(MIN(D2,F2,H2,J2)),"")

 

[Special-K99]

@jasonb75: That formula's giving me a "found a problem with the formula" error

@blimey88: That formula works for me
But you may want to restrict the cells so it doesn't look at columns E G H or K like this

=IF(D2="","",MIN(IF(MOD(COLUMN(D2:J2),2)=0,MIN(D2:J2)))

 

[blimey88]

=IF(D2="","",MIN(IF(MOD(COLUMN(D2:J2),2)=0,MIN(D2:J2)))

This does return the date, if all cells have a date in, it still won't return if there is only one date populated?

 

[jasonb75]

@jasonb75: That formula's giving me a "found a problem with the formula" error

One to many opening parentheses

=IFERROR(1/(1/MIN(D2,F2,H2,J2)),"" )

edit:-

You only need =MIN(D2,F2,H2,J2) if there will always be at least one date. The rest is just to blank the cell when all dates are empty.

 

[blimey88]

=IFERROR(1/(1/MIN(D2,F2,H2,J2)),"" )

BOOM! That works perfectly!

 

[Special-K99]

...it still won't return if there is only one date populated?

You just simply want

=MIN(IF(MOD(COLUMN(D2:J2),2)=0,MIN(D2:J2)))