Putting a List in Ascending Order and Skipping Duplicates

I have a list of dates (max of 6 dates possible in one column) that I need to put in ascending order and also combine duplicate dates into one listing. Here is an example:

Original:
05/23/2008
02/02/2005
<blank>
06/14/2001
02/02/2005
<blank>

Formatted:
06/14/2001
02/02/2005
05/23/5008
<blank>
<blank>
<blank>

I need a formula that can do all of these steps at once. It would be EXTREMELY helpful. Thank you!

A quick way would be do a A-Z sort, then do a data-filter-advanced filter-unique records only.

md1972,

Normally this would work but I need the formatted list for further calculations (ie. average number of days between dates, etc.)

pb71,

Thanks for the quick response! I used your formula but here are the results I am getting using the sample data in my original post"

Original:
05/23/2008
02/02/2005
<blank>
06/14/2001
02/02/2005
<blank>

Formatted (using your formula):
02/02/2005
06/14/2001
05/23/5008
<blank>
<blank>
<blank>

So it is taking care of duplicates and blanks, but it is not in ascending order yet. Anyone know how to put them in ascending order? Thanks again!

Try this:

=IF(ISERROR(SMALL(IF(COUNTIF($B$1:B1,$A$2:$A$7)=0,$A$2:$A$7),1+COUNTBLANK($A$2:$A$7))),"",SMALL(IF(COUNTIF($B$1:B1,$A$2:$A$7)=0,$A$2:$A$7),1+COUNTBLANK($A$2:$A$7)))

entered with Ctrl+Shift+Enter

pb71,

That worked perfectly!! Thank you so much!

No problem AamerP86. I'm not having a good day! I don't know what I was thinking using LOOKUP.