#### Fin Fang Foom

##### Well-known Member

- Joined
- Mar 20, 2005

- Messages
- 598

I have dates like this in column A:

1060911

1060914

1060912

1060915

1060913

and so on...

I would like to get the smallest date and then the second and third smallest dates in column E.

It should look like this:

09/11/2006

09/12/2006

09/13/2006

I have this formula, it will get me the Min of the date.

=DATE(INT(MIN($A$2:$A$851/10000)),MID(MIN($A$2:$A$851),4,2),RIGHT(MIN($A$2:$A$851),2))

I tried to incorporate the small function into the formula to get the smallest dates but it does not work.

=DATE(INT(SMALL($A$2:$A$851,ROW(A1))/10000),MID(SMALL(Sheet2!$A$2:$A$851,ROW(A1)),4,2),RIGHT(SMALL($A$2:$A$851,ROW(A1)),2))

If possible I would like a all in one formula.