Dates Formatting Question - What if you do not know month and/or d
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
|