Hello all.

We have a spreadsheet wherein we have a column of dates that need to be
sorted as dates. Unfortunately, on some of them, we only know the month/year
or just the year. So, our column may look as such:

2005
10/2005
01/14/2006
2006
11/2004

We need to be able to sort these by date. Is there a way to format them for
that to happen? (i.e., something like this:

??/??/2005
10/??/2005
01/14/2006
??/??/2006
11/??/2004

To sort like:
11/??/2004
??/??/2005
10/??/2005
??/??/2006
01/14/2006

Thank you in advance for any advice!

Cheers,
Elf